/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50638
 Source Host           : localhost:3306
 Source Schema         : timewoods

 Target Server Type    : MySQL
 Target Server Version : 50638
 File Encoding         : 65001

 Date: 04/07/2018 11:13:15
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dp_admin_access
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_access`;
CREATE TABLE `dp_admin_access` (
  `module` varchar(16) NOT NULL DEFAULT '' COMMENT '模型名称',
  `group` varchar(16) NOT NULL DEFAULT '' COMMENT '权限分组标识',
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `nid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '授权节点id'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='统一授权表';

-- ----------------------------
-- Table structure for dp_admin_action
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_action`;
CREATE TABLE `dp_admin_action` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(16) NOT NULL DEFAULT '' COMMENT '所属模块名',
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '行为唯一标识',
  `title` varchar(80) NOT NULL DEFAULT '' COMMENT '行为标题',
  `remark` varchar(128) NOT NULL DEFAULT '' COMMENT '行为描述',
  `rule` text NOT NULL COMMENT '行为规则',
  `log` text NOT NULL COMMENT '日志规则',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COMMENT='系统行为表';

-- ----------------------------
-- Records of dp_admin_action
-- ----------------------------
BEGIN;
INSERT INTO `dp_admin_action` VALUES (1, 'user', 'user_add', '添加用户', '添加用户', '', '[user|get_nickname] 添加了用户：[record|get_nickname]', 1, 1480156399, 1480163853);
INSERT INTO `dp_admin_action` VALUES (2, 'user', 'user_edit', '编辑用户', '编辑用户', '', '[user|get_nickname] 编辑了用户：[details]', 1, 1480164578, 1480297748);
INSERT INTO `dp_admin_action` VALUES (3, 'user', 'user_delete', '删除用户', '删除用户', '', '[user|get_nickname] 删除了用户：[details]', 1, 1480168582, 1480168616);
INSERT INTO `dp_admin_action` VALUES (4, 'user', 'user_enable', '启用用户', '启用用户', '', '[user|get_nickname] 启用了用户：[details]', 1, 1480169185, 1480169185);
INSERT INTO `dp_admin_action` VALUES (5, 'user', 'user_disable', '禁用用户', '禁用用户', '', '[user|get_nickname] 禁用了用户：[details]', 1, 1480169214, 1480170581);
INSERT INTO `dp_admin_action` VALUES (6, 'user', 'user_access', '用户授权', '用户授权', '', '[user|get_nickname] 对用户：[record|get_nickname] 进行了授权操作。详情：[details]', 1, 1480221441, 1480221563);
INSERT INTO `dp_admin_action` VALUES (7, 'user', 'role_add', '添加角色', '添加角色', '', '[user|get_nickname] 添加了角色：[details]', 1, 1480251473, 1480251473);
INSERT INTO `dp_admin_action` VALUES (8, 'user', 'role_edit', '编辑角色', '编辑角色', '', '[user|get_nickname] 编辑了角色：[details]', 1, 1480252369, 1480252369);
INSERT INTO `dp_admin_action` VALUES (9, 'user', 'role_delete', '删除角色', '删除角色', '', '[user|get_nickname] 删除了角色：[details]', 1, 1480252580, 1480252580);
INSERT INTO `dp_admin_action` VALUES (10, 'user', 'role_enable', '启用角色', '启用角色', '', '[user|get_nickname] 启用了角色：[details]', 1, 1480252620, 1480252620);
INSERT INTO `dp_admin_action` VALUES (11, 'user', 'role_disable', '禁用角色', '禁用角色', '', '[user|get_nickname] 禁用了角色：[details]', 1, 1480252651, 1480252651);
INSERT INTO `dp_admin_action` VALUES (12, 'user', 'attachment_enable', '启用附件', '启用附件', '', '[user|get_nickname] 启用了附件：附件ID([details])', 1, 1480253226, 1480253332);
INSERT INTO `dp_admin_action` VALUES (13, 'user', 'attachment_disable', '禁用附件', '禁用附件', '', '[user|get_nickname] 禁用了附件：附件ID([details])', 1, 1480253267, 1480253340);
INSERT INTO `dp_admin_action` VALUES (14, 'user', 'attachment_delete', '删除附件', '删除附件', '', '[user|get_nickname] 删除了附件：附件ID([details])', 1, 1480253323, 1480253323);
INSERT INTO `dp_admin_action` VALUES (15, 'admin', 'config_add', '添加配置', '添加配置', '', '[user|get_nickname] 添加了配置，[details]', 1, 1480296196, 1480296196);
INSERT INTO `dp_admin_action` VALUES (16, 'admin', 'config_edit', '编辑配置', '编辑配置', '', '[user|get_nickname] 编辑了配置：[details]', 1, 1480296960, 1480296960);
INSERT INTO `dp_admin_action` VALUES (17, 'admin', 'config_enable', '启用配置', '启用配置', '', '[user|get_nickname] 启用了配置：[details]', 1, 1480298479, 1480298479);
INSERT INTO `dp_admin_action` VALUES (18, 'admin', 'config_disable', '禁用配置', '禁用配置', '', '[user|get_nickname] 禁用了配置：[details]', 1, 1480298506, 1480298506);
INSERT INTO `dp_admin_action` VALUES (19, 'admin', 'config_delete', '删除配置', '删除配置', '', '[user|get_nickname] 删除了配置：[details]', 1, 1480298532, 1480298532);
INSERT INTO `dp_admin_action` VALUES (20, 'admin', 'database_export', '备份数据库', '备份数据库', '', '[user|get_nickname] 备份了数据库：[details]', 1, 1480298946, 1480298946);
INSERT INTO `dp_admin_action` VALUES (21, 'admin', 'database_import', '还原数据库', '还原数据库', '', '[user|get_nickname] 还原了数据库：[details]', 1, 1480301990, 1480302022);
INSERT INTO `dp_admin_action` VALUES (22, 'admin', 'database_optimize', '优化数据表', '优化数据表', '', '[user|get_nickname] 优化了数据表：[details]', 1, 1480302616, 1480302616);
INSERT INTO `dp_admin_action` VALUES (23, 'admin', 'database_repair', '修复数据表', '修复数据表', '', '[user|get_nickname] 修复了数据表：[details]', 1, 1480302798, 1480302798);
INSERT INTO `dp_admin_action` VALUES (24, 'admin', 'database_backup_delete', '删除数据库备份', '删除数据库备份', '', '[user|get_nickname] 删除了数据库备份：[details]', 1, 1480302870, 1480302870);
INSERT INTO `dp_admin_action` VALUES (25, 'admin', 'hook_add', '添加钩子', '添加钩子', '', '[user|get_nickname] 添加了钩子：[details]', 1, 1480303198, 1480303198);
INSERT INTO `dp_admin_action` VALUES (26, 'admin', 'hook_edit', '编辑钩子', '编辑钩子', '', '[user|get_nickname] 编辑了钩子：[details]', 1, 1480303229, 1480303229);
INSERT INTO `dp_admin_action` VALUES (27, 'admin', 'hook_delete', '删除钩子', '删除钩子', '', '[user|get_nickname] 删除了钩子：[details]', 1, 1480303264, 1480303264);
INSERT INTO `dp_admin_action` VALUES (28, 'admin', 'hook_enable', '启用钩子', '启用钩子', '', '[user|get_nickname] 启用了钩子：[details]', 1, 1480303294, 1480303294);
INSERT INTO `dp_admin_action` VALUES (29, 'admin', 'hook_disable', '禁用钩子', '禁用钩子', '', '[user|get_nickname] 禁用了钩子：[details]', 1, 1480303409, 1480303409);
INSERT INTO `dp_admin_action` VALUES (30, 'admin', 'menu_add', '添加节点', '添加节点', '', '[user|get_nickname] 添加了节点：[details]', 1, 1480305468, 1480305468);
INSERT INTO `dp_admin_action` VALUES (31, 'admin', 'menu_edit', '编辑节点', '编辑节点', '', '[user|get_nickname] 编辑了节点：[details]', 1, 1480305513, 1480305513);
INSERT INTO `dp_admin_action` VALUES (32, 'admin', 'menu_delete', '删除节点', '删除节点', '', '[user|get_nickname] 删除了节点：[details]', 1, 1480305562, 1480305562);
INSERT INTO `dp_admin_action` VALUES (33, 'admin', 'menu_enable', '启用节点', '启用节点', '', '[user|get_nickname] 启用了节点：[details]', 1, 1480305630, 1480305630);
INSERT INTO `dp_admin_action` VALUES (34, 'admin', 'menu_disable', '禁用节点', '禁用节点', '', '[user|get_nickname] 禁用了节点：[details]', 1, 1480305659, 1480305659);
INSERT INTO `dp_admin_action` VALUES (35, 'admin', 'module_install', '安装模块', '安装模块', '', '[user|get_nickname] 安装了模块：[details]', 1, 1480307558, 1480307558);
INSERT INTO `dp_admin_action` VALUES (36, 'admin', 'module_uninstall', '卸载模块', '卸载模块', '', '[user|get_nickname] 卸载了模块：[details]', 1, 1480307588, 1480307588);
INSERT INTO `dp_admin_action` VALUES (37, 'admin', 'module_enable', '启用模块', '启用模块', '', '[user|get_nickname] 启用了模块：[details]', 1, 1480307618, 1480307618);
INSERT INTO `dp_admin_action` VALUES (38, 'admin', 'module_disable', '禁用模块', '禁用模块', '', '[user|get_nickname] 禁用了模块：[details]', 1, 1480307653, 1480307653);
INSERT INTO `dp_admin_action` VALUES (39, 'admin', 'module_export', '导出模块', '导出模块', '', '[user|get_nickname] 导出了模块：[details]', 1, 1480307682, 1480307682);
INSERT INTO `dp_admin_action` VALUES (40, 'admin', 'packet_install', '安装数据包', '安装数据包', '', '[user|get_nickname] 安装了数据包：[details]', 1, 1480308342, 1480308342);
INSERT INTO `dp_admin_action` VALUES (41, 'admin', 'packet_uninstall', '卸载数据包', '卸载数据包', '', '[user|get_nickname] 卸载了数据包：[details]', 1, 1480308372, 1480308372);
INSERT INTO `dp_admin_action` VALUES (42, 'admin', 'system_config_update', '更新系统设置', '更新系统设置', '', '[user|get_nickname] 更新了系统设置：[details]', 1, 1480309555, 1480309642);
INSERT INTO `dp_admin_action` VALUES (43, 'cms', 'slider_delete', '删除滚动图片', '删除滚动图片', '', '[user|get_nickname] 删除了滚动图片：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (44, 'cms', 'slider_edit', '编辑滚动图片', '编辑滚动图片', '', '[user|get_nickname] 编辑了滚动图片：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (45, 'cms', 'slider_add', '添加滚动图片', '添加滚动图片', '', '[user|get_nickname] 添加了滚动图片：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (46, 'cms', 'document_delete', '删除文档', '删除文档', '', '[user|get_nickname] 删除了文档：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (47, 'cms', 'document_restore', '还原文档', '还原文档', '', '[user|get_nickname] 还原了文档：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (48, 'cms', 'nav_disable', '禁用导航', '禁用导航', '', '[user|get_nickname] 禁用了导航：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (49, 'cms', 'nav_enable', '启用导航', '启用导航', '', '[user|get_nickname] 启用了导航：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (50, 'cms', 'nav_delete', '删除导航', '删除导航', '', '[user|get_nickname] 删除了导航：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (51, 'cms', 'nav_edit', '编辑导航', '编辑导航', '', '[user|get_nickname] 编辑了导航：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (52, 'cms', 'nav_add', '添加导航', '添加导航', '', '[user|get_nickname] 添加了导航：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (53, 'cms', 'model_disable', '禁用内容模型', '禁用内容模型', '', '[user|get_nickname] 禁用了内容模型：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (54, 'cms', 'model_enable', '启用内容模型', '启用内容模型', '', '[user|get_nickname] 启用了内容模型：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (55, 'cms', 'model_delete', '删除内容模型', '删除内容模型', '', '[user|get_nickname] 删除了内容模型：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (56, 'cms', 'model_edit', '编辑内容模型', '编辑内容模型', '', '[user|get_nickname] 编辑了内容模型：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (57, 'cms', 'model_add', '添加内容模型', '添加内容模型', '', '[user|get_nickname] 添加了内容模型：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (58, 'cms', 'menu_disable', '禁用导航菜单', '禁用导航菜单', '', '[user|get_nickname] 禁用了导航菜单：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (59, 'cms', 'menu_enable', '启用导航菜单', '启用导航菜单', '', '[user|get_nickname] 启用了导航菜单：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (60, 'cms', 'menu_delete', '删除导航菜单', '删除导航菜单', '', '[user|get_nickname] 删除了导航菜单：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (61, 'cms', 'menu_edit', '编辑导航菜单', '编辑导航菜单', '', '[user|get_nickname] 编辑了导航菜单：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (62, 'cms', 'menu_add', '添加导航菜单', '添加导航菜单', '', '[user|get_nickname] 添加了导航菜单：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (63, 'cms', 'link_disable', '禁用友情链接', '禁用友情链接', '', '[user|get_nickname] 禁用了友情链接：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (64, 'cms', 'link_enable', '启用友情链接', '启用友情链接', '', '[user|get_nickname] 启用了友情链接：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (65, 'cms', 'link_delete', '删除友情链接', '删除友情链接', '', '[user|get_nickname] 删除了友情链接：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (66, 'cms', 'link_edit', '编辑友情链接', '编辑友情链接', '', '[user|get_nickname] 编辑了友情链接：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (67, 'cms', 'link_add', '添加友情链接', '添加友情链接', '', '[user|get_nickname] 添加了友情链接：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (68, 'cms', 'field_disable', '禁用模型字段', '禁用模型字段', '', '[user|get_nickname] 禁用了模型字段：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (69, 'cms', 'field_enable', '启用模型字段', '启用模型字段', '', '[user|get_nickname] 启用了模型字段：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (70, 'cms', 'field_delete', '删除模型字段', '删除模型字段', '', '[user|get_nickname] 删除了模型字段：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (71, 'cms', 'field_edit', '编辑模型字段', '编辑模型字段', '', '[user|get_nickname] 编辑了模型字段：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (72, 'cms', 'field_add', '添加模型字段', '添加模型字段', '', '[user|get_nickname] 添加了模型字段：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (73, 'cms', 'column_disable', '禁用栏目', '禁用栏目', '', '[user|get_nickname] 禁用了栏目：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (74, 'cms', 'column_enable', '启用栏目', '启用栏目', '', '[user|get_nickname] 启用了栏目：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (75, 'cms', 'column_delete', '删除栏目', '删除栏目', '', '[user|get_nickname] 删除了栏目：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (76, 'cms', 'column_edit', '编辑栏目', '编辑栏目', '', '[user|get_nickname] 编辑了栏目：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (77, 'cms', 'column_add', '添加栏目', '添加栏目', '', '[user|get_nickname] 添加了栏目：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (78, 'cms', 'advert_type_disable', '禁用广告分类', '禁用广告分类', '', '[user|get_nickname] 禁用了广告分类：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (79, 'cms', 'advert_type_enable', '启用广告分类', '启用广告分类', '', '[user|get_nickname] 启用了广告分类：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (80, 'cms', 'advert_type_delete', '删除广告分类', '删除广告分类', '', '[user|get_nickname] 删除了广告分类：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (81, 'cms', 'advert_type_edit', '编辑广告分类', '编辑广告分类', '', '[user|get_nickname] 编辑了广告分类：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (82, 'cms', 'advert_type_add', '添加广告分类', '添加广告分类', '', '[user|get_nickname] 添加了广告分类：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (83, 'cms', 'advert_disable', '禁用广告', '禁用广告', '', '[user|get_nickname] 禁用了广告：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (84, 'cms', 'advert_enable', '启用广告', '启用广告', '', '[user|get_nickname] 启用了广告：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (85, 'cms', 'advert_delete', '删除广告', '删除广告', '', '[user|get_nickname] 删除了广告：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (86, 'cms', 'advert_edit', '编辑广告', '编辑广告', '', '[user|get_nickname] 编辑了广告：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (87, 'cms', 'advert_add', '添加广告', '添加广告', '', '[user|get_nickname] 添加了广告：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (88, 'cms', 'document_disable', '禁用文档', '禁用文档', '', '[user|get_nickname] 禁用了文档：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (89, 'cms', 'document_enable', '启用文档', '启用文档', '', '[user|get_nickname] 启用了文档：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (90, 'cms', 'document_trash', '回收文档', '回收文档', '', '[user|get_nickname] 回收了文档：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (91, 'cms', 'document_edit', '编辑文档', '编辑文档', '', '[user|get_nickname] 编辑了文档：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (92, 'cms', 'document_add', '添加文档', '添加文档', '', '[user|get_nickname] 添加了文档：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (93, 'cms', 'slider_enable', '启用滚动图片', '启用滚动图片', '', '[user|get_nickname] 启用了滚动图片：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (94, 'cms', 'slider_disable', '禁用滚动图片', '禁用滚动图片', '', '[user|get_nickname] 禁用了滚动图片：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (95, 'cms', 'support_add', '添加客服', '添加客服', '', '[user|get_nickname] 添加了客服：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (96, 'cms', 'support_edit', '编辑客服', '编辑客服', '', '[user|get_nickname] 编辑了客服：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (97, 'cms', 'support_delete', '删除客服', '删除客服', '', '[user|get_nickname] 删除了客服：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (98, 'cms', 'support_enable', '启用客服', '启用客服', '', '[user|get_nickname] 启用了客服：[details]', 1, 1530582239, 1530582239);
INSERT INTO `dp_admin_action` VALUES (99, 'cms', 'support_disable', '禁用客服', '禁用客服', '', '[user|get_nickname] 禁用了客服：[details]', 1, 1530582239, 1530582239);
COMMIT;

-- ----------------------------
-- Table structure for dp_admin_attachment
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_attachment`;
CREATE TABLE `dp_admin_attachment` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '文件名',
  `module` varchar(32) NOT NULL DEFAULT '' COMMENT '模块名，由哪个模块上传的',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '文件路径',
  `thumb` varchar(255) NOT NULL DEFAULT '' COMMENT '缩略图路径',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '文件链接',
  `mime` varchar(128) NOT NULL DEFAULT '' COMMENT '文件mime类型',
  `ext` char(8) NOT NULL DEFAULT '' COMMENT '文件类型',
  `size` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5',
  `sha1` char(40) NOT NULL DEFAULT '' COMMENT 'sha1 散列值',
  `driver` varchar(16) NOT NULL DEFAULT 'local' COMMENT '上传驱动',
  `download` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '下载次数',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  `width` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '图片宽度',
  `height` int(8) unsigned NOT NULL DEFAULT '0' COMMENT '图片高度',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='附件表';

-- ----------------------------
-- Records of dp_admin_attachment
-- ----------------------------
BEGIN;
INSERT INTO `dp_admin_attachment` VALUES (1, 1, '山桐子1.JPG', 'groupbuy', 'http://timeappthree.ssjtime.cn/17852f1840ffee143825fcb00a2a2979.JPG?v=312844', '', '', 'image/jpeg', 'JPG', 458501, '17852f1840ffee143825fcb00a2a2979', '0dff82cf5aa2331ecf05987263a17f835deaad6f', 'qiniu', 0, 1530671525, 1530671525, 100, 1, 900, 600);
INSERT INTO `dp_admin_attachment` VALUES (2, 1, 'timg.jpg', 'groupbuy', 'http://timeappthree.ssjtime.cn/85c1f8b7806100320a2063a093d54b72.jpg?v=469178', '', '', 'image/jpeg', 'jpg', 24638, '85c1f8b7806100320a2063a093d54b72', 'da41b722e5b38d2b040ad8f5f65d554b22ce94e4', 'qiniu', 0, 1530671586, 1530671586, 100, 1, 500, 346);
COMMIT;

-- ----------------------------
-- Table structure for dp_admin_config
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_config`;
CREATE TABLE `dp_admin_config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT '' COMMENT '名称',
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '标题',
  `group` varchar(32) NOT NULL DEFAULT '' COMMENT '配置分组',
  `type` varchar(32) NOT NULL DEFAULT '' COMMENT '类型',
  `value` text NOT NULL COMMENT '配置值',
  `options` text NOT NULL COMMENT '配置项',
  `tips` varchar(256) NOT NULL DEFAULT '' COMMENT '配置提示',
  `ajax_url` varchar(256) NOT NULL DEFAULT '' COMMENT '联动下拉框ajax地址',
  `next_items` varchar(256) NOT NULL DEFAULT '' COMMENT '联动下拉框的下级下拉框名，多个以逗号隔开',
  `param` varchar(32) NOT NULL DEFAULT '' COMMENT '联动下拉框请求参数名',
  `format` varchar(32) NOT NULL DEFAULT '' COMMENT '格式，用于格式文本',
  `table` varchar(32) NOT NULL DEFAULT '' COMMENT '表名，只用于快速联动类型',
  `level` tinyint(2) unsigned NOT NULL DEFAULT '2' COMMENT '联动级别，只用于快速联动类型',
  `key` varchar(32) NOT NULL DEFAULT '' COMMENT '键字段，只用于快速联动类型',
  `option` varchar(32) NOT NULL DEFAULT '' COMMENT '值字段，只用于快速联动类型',
  `pid` varchar(32) NOT NULL DEFAULT '' COMMENT '父级id字段，只用于快速联动类型',
  `ak` varchar(32) NOT NULL DEFAULT '' COMMENT '百度地图appkey',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态：0禁用，1启用',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COMMENT='系统配置表';

-- ----------------------------
-- Records of dp_admin_config
-- ----------------------------
BEGIN;
INSERT INTO `dp_admin_config` VALUES (1, 'web_site_status', '站点开关', 'base', 'switch', '1', '', '站点关闭后将不能访问，后台可正常登录', '', '', '', '', '', 2, '', '', '', '', 1475240395, 1477403914, 1, 1);
INSERT INTO `dp_admin_config` VALUES (2, 'web_site_title', '站点标题', 'base', 'text', '海豚PHP', '', '调用方式：<code>config(\'web_site_title\')</code>', '', '', '', '', '', 2, '', '', '', '', 1475240646, 1477710341, 2, 1);
INSERT INTO `dp_admin_config` VALUES (3, 'web_site_slogan', '站点标语', 'base', 'text', '海豚PHP，极简、极速、极致', '', '站点口号，调用方式：<code>config(\'web_site_slogan\')</code>', '', '', '', '', '', 2, '', '', '', '', 1475240994, 1477710357, 3, 1);
INSERT INTO `dp_admin_config` VALUES (4, 'web_site_logo', '站点LOGO', 'base', 'image', '', '', '', '', '', '', '', '', 2, '', '', '', '', 1475241067, 1475241067, 4, 1);
INSERT INTO `dp_admin_config` VALUES (5, 'web_site_description', '站点描述', 'base', 'textarea', '', '', '网站描述，有利于搜索引擎抓取相关信息', '', '', '', '', '', 2, '', '', '', '', 1475241186, 1475241186, 6, 1);
INSERT INTO `dp_admin_config` VALUES (6, 'web_site_keywords', '站点关键词', 'base', 'text', '海豚PHP、PHP开发框架、后台框架', '', '网站搜索引擎关键字', '', '', '', '', '', 2, '', '', '', '', 1475241328, 1475241328, 7, 1);
INSERT INTO `dp_admin_config` VALUES (7, 'web_site_copyright', '版权信息', 'base', 'text', 'Copyright © 2015-2017 DolphinPHP All rights reserved.', '', '调用方式：<code>config(\'web_site_copyright\')</code>', '', '', '', '', '', 2, '', '', '', '', 1475241416, 1477710383, 8, 1);
INSERT INTO `dp_admin_config` VALUES (8, 'web_site_icp', '备案信息', 'base', 'text', '', '', '调用方式：<code>config(\'web_site_icp\')</code>', '', '', '', '', '', 2, '', '', '', '', 1475241441, 1477710441, 9, 1);
INSERT INTO `dp_admin_config` VALUES (9, 'web_site_statistics', '站点统计', 'base', 'textarea', '', '', '网站统计代码，支持百度、Google、cnzz等，调用方式：<code>config(\'web_site_statistics\')</code>', '', '', '', '', '', 2, '', '', '', '', 1475241498, 1477710455, 10, 1);
INSERT INTO `dp_admin_config` VALUES (10, 'config_group', '配置分组', 'system', 'array', 'base:基本\r\nsystem:系统\r\nupload:上传\r\ndevelop:开发\r\ndatabase:数据库', '', '', '', '', '', '', '', 2, '', '', '', '', 1475241716, 1477649446, 100, 1);
INSERT INTO `dp_admin_config` VALUES (11, 'form_item_type', '配置类型', 'system', 'array', 'text:单行文本\r\ntextarea:多行文本\r\nstatic:静态文本\r\npassword:密码\r\ncheckbox:复选框\r\nradio:单选按钮\r\ndate:日期\r\ndatetime:日期+时间\r\nhidden:隐藏\r\nswitch:开关\r\narray:数组\r\nselect:下拉框\r\nlinkage:普通联动下拉框\r\nlinkages:快速联动下拉框\r\nimage:单张图片\r\nimages:多张图片\r\nfile:单个文件\r\nfiles:多个文件\r\nueditor:UEditor 编辑器\r\nwangeditor:wangEditor 编辑器\r\neditormd:markdown 编辑器\r\nckeditor:ckeditor 编辑器\r\nicon:字体图标\r\ntags:标签\r\nnumber:数字\r\nbmap:百度地图\r\ncolorpicker:取色器\r\njcrop:图片裁剪\r\nmasked:格式文本\r\nrange:范围\r\ntime:时间', '', '', '', '', '', '', '', 2, '', '', '', '', 1475241835, 1495853193, 100, 1);
INSERT INTO `dp_admin_config` VALUES (12, 'upload_file_size', '文件上传大小限制', 'upload', 'text', '0', '', '0为不限制大小，单位：kb', '', '', '', '', '', 2, '', '', '', '', 1475241897, 1477663520, 100, 1);
INSERT INTO `dp_admin_config` VALUES (13, 'upload_file_ext', '允许上传的文件后缀', 'upload', 'tags', 'doc,docx,xls,xlsx,ppt,pptx,pdf,wps,txt,rar,zip,gz,bz2,7z', '', '多个后缀用逗号隔开，不填写则不限制类型', '', '', '', '', '', 2, '', '', '', '', 1475241975, 1477649489, 100, 1);
INSERT INTO `dp_admin_config` VALUES (14, 'upload_image_size', '图片上传大小限制', 'upload', 'text', '0', '', '0为不限制大小，单位：kb', '', '', '', '', '', 2, '', '', '', '', 1475242015, 1477663529, 100, 1);
INSERT INTO `dp_admin_config` VALUES (15, 'upload_image_ext', '允许上传的图片后缀', 'upload', 'tags', 'gif,jpg,jpeg,bmp,png', '', '多个后缀用逗号隔开，不填写则不限制类型', '', '', '', '', '', 2, '', '', '', '', 1475242056, 1477649506, 100, 1);
INSERT INTO `dp_admin_config` VALUES (16, 'list_rows', '分页数量', 'system', 'number', '20', '', '每页的记录数', '', '', '', '', '', 2, '', '', '', '', 1475242066, 1476074507, 101, 1);
INSERT INTO `dp_admin_config` VALUES (17, 'system_color', '后台配色方案', 'system', 'radio', 'default', 'default:Default\r\namethyst:Amethyst\r\ncity:City\r\nflat:Flat\r\nmodern:Modern\r\nsmooth:Smooth', '', '', '', '', '', '', 2, '', '', '', '', 1475250066, 1477316689, 102, 1);
INSERT INTO `dp_admin_config` VALUES (18, 'develop_mode', '开发模式', 'develop', 'radio', '1', '0:关闭\r\n1:开启', '', '', '', '', '', '', 2, '', '', '', '', 1476864205, 1476864231, 100, 1);
INSERT INTO `dp_admin_config` VALUES (19, 'app_trace', '显示页面Trace', 'develop', 'radio', '0', '0:否\r\n1:是', '', '', '', '', '', '', 2, '', '', '', '', 1476866355, 1476866355, 100, 1);
INSERT INTO `dp_admin_config` VALUES (21, 'data_backup_path', '数据库备份根路径', 'database', 'text', '../data/', '', '路径必须以 / 结尾', '', '', '', '', '', 2, '', '', '', '', 1477017745, 1477018467, 100, 1);
INSERT INTO `dp_admin_config` VALUES (22, 'data_backup_part_size', '数据库备份卷大小', 'database', 'text', '20971520', '', '该值用于限制压缩后的分卷最大长度。单位：B；建议设置20M', '', '', '', '', '', 2, '', '', '', '', 1477017886, 1477017886, 100, 1);
INSERT INTO `dp_admin_config` VALUES (23, 'data_backup_compress', '数据库备份文件是否启用压缩', 'database', 'radio', '1', '0:否\r\n1:是', '压缩备份文件需要PHP环境支持 <code>gzopen</code>, <code>gzwrite</code>函数', '', '', '', '', '', 2, '', '', '', '', 1477017978, 1477018172, 100, 1);
INSERT INTO `dp_admin_config` VALUES (24, 'data_backup_compress_level', '数据库备份文件压缩级别', 'database', 'radio', '9', '1:最低\r\n4:一般\r\n9:最高', '数据库备份文件的压缩级别，该配置在开启压缩时生效', '', '', '', '', '', 2, '', '', '', '', 1477018083, 1477018083, 100, 1);
INSERT INTO `dp_admin_config` VALUES (25, 'top_menu_max', '顶部导航模块数量', 'system', 'text', '10', '', '设置顶部导航默认显示的模块数量', '', '', '', '', '', 2, '', '', '', '', 1477579289, 1477579289, 103, 1);
INSERT INTO `dp_admin_config` VALUES (26, 'web_site_logo_text', '站点LOGO文字', 'base', 'image', '', '', '', '', '', '', '', '', 2, '', '', '', '', 1477620643, 1477620643, 5, 1);
INSERT INTO `dp_admin_config` VALUES (27, 'upload_image_thumb', '缩略图尺寸', 'upload', 'text', '', '', '不填写则不生成缩略图，如需生成 <code>300x300</code> 的缩略图，则填写 <code>300,300</code> ，请注意，逗号必须是英文逗号', '', '', '', '', '', 2, '', '', '', '', 1477644150, 1477649513, 100, 1);
INSERT INTO `dp_admin_config` VALUES (28, 'upload_image_thumb_type', '缩略图裁剪类型', 'upload', 'radio', '1', '1:等比例缩放\r\n2:缩放后填充\r\n3:居中裁剪\r\n4:左上角裁剪\r\n5:右下角裁剪\r\n6:固定尺寸缩放', '该项配置只有在启用生成缩略图时才生效', '', '', '', '', '', 2, '', '', '', '', 1477646271, 1477649521, 100, 1);
INSERT INTO `dp_admin_config` VALUES (29, 'upload_thumb_water', '添加水印', 'upload', 'switch', '0', '', '', '', '', '', '', '', 2, '', '', '', '', 1477649648, 1477649648, 100, 1);
INSERT INTO `dp_admin_config` VALUES (30, 'upload_thumb_water_pic', '水印图片', 'upload', 'image', '', '', '只有开启水印功能才生效', '', '', '', '', '', 2, '', '', '', '', 1477656390, 1477656390, 100, 1);
INSERT INTO `dp_admin_config` VALUES (31, 'upload_thumb_water_position', '水印位置', 'upload', 'radio', '9', '1:左上角\r\n2:上居中\r\n3:右上角\r\n4:左居中\r\n5:居中\r\n6:右居中\r\n7:左下角\r\n8:下居中\r\n9:右下角', '只有开启水印功能才生效', '', '', '', '', '', 2, '', '', '', '', 1477656528, 1477656528, 100, 1);
INSERT INTO `dp_admin_config` VALUES (32, 'upload_thumb_water_alpha', '水印透明度', 'upload', 'text', '50', '', '请输入0~100之间的数字，数字越小，透明度越高', '', '', '', '', '', 2, '', '', '', '', 1477656714, 1477661309, 100, 1);
INSERT INTO `dp_admin_config` VALUES (33, 'wipe_cache_type', '清除缓存类型', 'system', 'checkbox', 'TEMP_PATH', 'TEMP_PATH:应用缓存\r\nLOG_PATH:应用日志\r\nCACHE_PATH:项目模板缓存', '清除缓存时，要删除的缓存类型', '', '', '', '', '', 2, '', '', '', '', 1477727305, 1477727305, 100, 1);
INSERT INTO `dp_admin_config` VALUES (34, 'captcha_signin', '后台验证码开关', 'system', 'switch', '0', '', '后台登录时是否需要验证码', '', '', '', '', '', 2, '', '', '', '', 1478771958, 1478771958, 99, 1);
INSERT INTO `dp_admin_config` VALUES (35, 'home_default_module', '前台默认模块', 'system', 'select', 'index', '', '前台默认访问的模块，该模块必须有Index控制器和index方法', '', '', '', '', '', 0, '', '', '', '', 1486714723, 1486715620, 104, 1);
INSERT INTO `dp_admin_config` VALUES (36, 'minify_status', '开启minify', 'system', 'switch', '0', '', '开启minify会压缩合并js、css文件，可以减少资源请求次数，如果不支持minify，可关闭', '', '', '', '', '', 0, '', '', '', '', 1487035843, 1487035843, 99, 1);
INSERT INTO `dp_admin_config` VALUES (37, 'upload_driver', '上传驱动', 'upload', 'radio', 'qiniu', 'local:本地\nqiniu:七牛云', '图片或文件上传驱动', '', '', '', '', '', 0, '', '', '', '', 1501488567, 1501490821, 100, 1);
INSERT INTO `dp_admin_config` VALUES (38, 'system_log', '系统日志', 'system', 'switch', '1', '', '是否开启系统日志功能', '', '', '', '', '', 0, '', '', '', '', 1512635391, 1512635391, 99, 1);
INSERT INTO `dp_admin_config` VALUES (39, 'asset_version', '资源版本号', 'develop', 'text', '20180327', '', '可通过修改版号强制用户更新静态文件', '', '', '', '', '', 0, '', '', '', '', 1522143239, 1522143239, 100, 1);
COMMIT;

-- ----------------------------
-- Table structure for dp_admin_hook
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_hook`;
CREATE TABLE `dp_admin_hook` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '钩子名称',
  `plugin` varchar(32) NOT NULL DEFAULT '' COMMENT '钩子来自哪个插件',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '钩子描述',
  `system` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否为系统钩子',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='钩子表';

-- ----------------------------
-- Records of dp_admin_hook
-- ----------------------------
BEGIN;
INSERT INTO `dp_admin_hook` VALUES (1, 'admin_index', '', '后台首页', 1, 1468174214, 1477757518, 1);
INSERT INTO `dp_admin_hook` VALUES (2, 'plugin_index_tab_list', '', '插件扩展tab钩子', 1, 1468174214, 1468174214, 1);
INSERT INTO `dp_admin_hook` VALUES (3, 'module_index_tab_list', '', '模块扩展tab钩子', 1, 1468174214, 1468174214, 1);
INSERT INTO `dp_admin_hook` VALUES (4, 'page_tips', '', '每个页面的提示', 1, 1468174214, 1468174214, 1);
INSERT INTO `dp_admin_hook` VALUES (5, 'signin_footer', '', '登录页面底部钩子', 1, 1479269315, 1479269315, 1);
INSERT INTO `dp_admin_hook` VALUES (6, 'signin_captcha', '', '登录页面验证码钩子', 1, 1479269315, 1479269315, 1);
INSERT INTO `dp_admin_hook` VALUES (7, 'signin', '', '登录控制器钩子', 1, 1479386875, 1479386875, 1);
INSERT INTO `dp_admin_hook` VALUES (8, 'upload_attachment', '', '附件上传钩子', 1, 1501493808, 1501493808, 1);
INSERT INTO `dp_admin_hook` VALUES (9, 'page_plugin_js', '', '页面插件js钩子', 1, 1503633591, 1503633591, 1);
INSERT INTO `dp_admin_hook` VALUES (10, 'page_plugin_css', '', '页面插件css钩子', 1, 1503633591, 1503633591, 1);
INSERT INTO `dp_admin_hook` VALUES (11, 'signin_sso', '', '单点登录钩子', 1, 1503633591, 1503633591, 1);
INSERT INTO `dp_admin_hook` VALUES (12, 'signout_sso', '', '单点退出钩子', 1, 1503633591, 1503633591, 1);
INSERT INTO `dp_admin_hook` VALUES (13, 'user_add', '', '添加用户钩子', 1, 1503633591, 1503633591, 1);
INSERT INTO `dp_admin_hook` VALUES (14, 'user_edit', '', '编辑用户钩子', 1, 1503633591, 1503633591, 1);
INSERT INTO `dp_admin_hook` VALUES (15, 'user_delete', '', '删除用户钩子', 1, 1503633591, 1503633591, 1);
INSERT INTO `dp_admin_hook` VALUES (16, 'user_enable', '', '启用用户钩子', 1, 1503633591, 1503633591, 1);
INSERT INTO `dp_admin_hook` VALUES (17, 'user_disable', '', '禁用用户钩子', 1, 1503633591, 1503633591, 1);
COMMIT;

-- ----------------------------
-- Table structure for dp_admin_hook_plugin
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_hook_plugin`;
CREATE TABLE `dp_admin_hook_plugin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `hook` varchar(32) NOT NULL DEFAULT '' COMMENT '钩子id',
  `plugin` varchar(32) NOT NULL DEFAULT '' COMMENT '插件标识',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='钩子-插件对应表';

-- ----------------------------
-- Records of dp_admin_hook_plugin
-- ----------------------------
BEGIN;
INSERT INTO `dp_admin_hook_plugin` VALUES (1, 'admin_index', 'SystemInfo', 1477757503, 1477757503, 1, 1);
INSERT INTO `dp_admin_hook_plugin` VALUES (2, 'admin_index', 'DevTeam', 1477755780, 1477755780, 2, 1);
INSERT INTO `dp_admin_hook_plugin` VALUES (3, 'upload_attachment', 'QiNiu', 1530582171, 1530582171, 100, 1);
COMMIT;

-- ----------------------------
-- Table structure for dp_admin_icon
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_icon`;
CREATE TABLE `dp_admin_icon` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '图标名称',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '图标css地址',
  `prefix` varchar(32) NOT NULL DEFAULT '' COMMENT '图标前缀',
  `font_family` varchar(32) NOT NULL DEFAULT '' COMMENT '字体名',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='图标表';

-- ----------------------------
-- Table structure for dp_admin_icon_list
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_icon_list`;
CREATE TABLE `dp_admin_icon_list` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `icon_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '所属图标id',
  `title` varchar(128) NOT NULL DEFAULT '' COMMENT '图标标题',
  `class` varchar(255) NOT NULL DEFAULT '' COMMENT '图标类名',
  `code` varchar(128) NOT NULL DEFAULT '' COMMENT '图标关键词',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='详细图标列表';

-- ----------------------------
-- Table structure for dp_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_log`;
CREATE TABLE `dp_admin_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `action_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '行为id',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '执行用户id',
  `action_ip` bigint(20) NOT NULL COMMENT '执行行为者ip',
  `model` varchar(50) NOT NULL DEFAULT '' COMMENT '触发行为的表',
  `record_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '触发行为的数据id',
  `remark` longtext NOT NULL COMMENT '日志备注',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '执行行为的时间',
  PRIMARY KEY (`id`),
  KEY `action_ip_ix` (`action_ip`),
  KEY `action_id_ix` (`action_id`),
  KEY `user_id_ix` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='行为日志表';

-- ----------------------------
-- Records of dp_admin_log
-- ----------------------------
BEGIN;
INSERT INTO `dp_admin_log` VALUES (1, 2, 1, 0, 'admin_user', 1, '超级管理员 编辑了用户：超级管理员', 1, 1530516101);
INSERT INTO `dp_admin_log` VALUES (2, 35, 1, 0, 'admin_module', 0, '超级管理员 安装了模块：门户', 1, 1530582238);
INSERT INTO `dp_admin_log` VALUES (3, 35, 1, 0, 'admin_module', 0, '超级管理员 安装了模块：定时任务', 1, 1530582248);
INSERT INTO `dp_admin_log` VALUES (4, 35, 1, 0, 'admin_module', 0, '超级管理员 安装了模块：微信支持', 1, 1530583858);
INSERT INTO `dp_admin_log` VALUES (5, 42, 1, 0, 'admin_config', 0, '超级管理员 更新了系统设置：分组(wechat)', 1, 1530585202);
INSERT INTO `dp_admin_log` VALUES (6, 35, 1, 0, 'admin_module', 0, '超级管理员 安装了模块：林主管理', 1, 1530590329);
INSERT INTO `dp_admin_log` VALUES (7, 35, 1, 0, 'admin_module', 0, '超级管理员 安装了模块：团购', 1, 1530610696);
INSERT INTO `dp_admin_log` VALUES (8, 36, 1, 0, 'admin_module', 0, '超级管理员 卸载了模块：团购', 1, 1530611821);
INSERT INTO `dp_admin_log` VALUES (9, 35, 1, 0, 'admin_module', 0, '超级管理员 安装了模块：团购', 1, 1530611830);
INSERT INTO `dp_admin_log` VALUES (10, 42, 1, 0, 'admin_config', 0, '超级管理员 更新了系统设置：分组(wechat)', 1, 1530670096);
INSERT INTO `dp_admin_log` VALUES (11, 36, 1, 0, 'admin_module', 0, '超级管理员 卸载了模块：团购', 1, 1530671058);
INSERT INTO `dp_admin_log` VALUES (12, 35, 1, 0, 'admin_module', 0, '超级管理员 安装了模块：团购', 1, 1530671066);
INSERT INTO `dp_admin_log` VALUES (13, 42, 1, 0, 'admin_config', 0, '超级管理员 更新了系统设置：分组(upload)', 1, 1530671418);
INSERT INTO `dp_admin_log` VALUES (14, 42, 1, 0, 'admin_config', 0, '超级管理员 更新了系统设置：分组(upload)', 1, 1530671508);
COMMIT;

-- ----------------------------
-- Table structure for dp_admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_menu`;
CREATE TABLE `dp_admin_menu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上级菜单id',
  `module` varchar(16) NOT NULL DEFAULT '' COMMENT '模块名称',
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '菜单标题',
  `icon` varchar(64) NOT NULL DEFAULT '' COMMENT '菜单图标',
  `url_type` varchar(16) NOT NULL DEFAULT '' COMMENT '链接类型（link：外链，module：模块）',
  `url_value` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `url_target` varchar(16) NOT NULL DEFAULT '_self' COMMENT '链接打开方式：_blank,_self',
  `online_hide` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '网站上线后是否隐藏',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
  `system_menu` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否为系统菜单，系统菜单不可删除',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  `params` varchar(255) NOT NULL DEFAULT '' COMMENT '参数',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=385 DEFAULT CHARSET=utf8 COMMENT='后台菜单表';

-- ----------------------------
-- Records of dp_admin_menu
-- ----------------------------
BEGIN;
INSERT INTO `dp_admin_menu` VALUES (1, 0, 'admin', '首页', 'fa fa-fw fa-home', 'module_admin', 'admin/index/index', '_self', 0, 1467617722, 1477710540, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (2, 1, 'admin', '快捷操作', 'fa fa-fw fa-folder-open-o', 'module_admin', '', '_self', 0, 1467618170, 1477710695, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (3, 2, 'admin', '清空缓存', 'fa fa-fw fa-trash-o', 'module_admin', 'admin/index/wipecache', '_self', 0, 1467618273, 1489049773, 3, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (4, 0, 'admin', '系统', 'fa fa-fw fa-gear', 'module_admin', 'admin/system/index', '_self', 0, 1467618361, 1477710540, 2, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (5, 4, 'admin', '系统功能', 'si si-wrench', 'module_admin', '', '_self', 0, 1467618441, 1477710695, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (6, 5, 'admin', '系统设置', 'fa fa-fw fa-wrench', 'module_admin', 'admin/system/index', '_self', 0, 1467618490, 1477710695, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (7, 5, 'admin', '配置管理', 'fa fa-fw fa-gears', 'module_admin', 'admin/config/index', '_self', 0, 1467618618, 1477710695, 2, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (8, 7, 'admin', '新增', '', 'module_admin', 'admin/config/add', '_self', 0, 1467618648, 1477710695, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (9, 7, 'admin', '编辑', '', 'module_admin', 'admin/config/edit', '_self', 0, 1467619566, 1477710695, 2, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (10, 7, 'admin', '删除', '', 'module_admin', 'admin/config/delete', '_self', 0, 1467619583, 1477710695, 3, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (11, 7, 'admin', '启用', '', 'module_admin', 'admin/config/enable', '_self', 0, 1467619609, 1477710695, 4, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (12, 7, 'admin', '禁用', '', 'module_admin', 'admin/config/disable', '_self', 0, 1467619637, 1477710695, 5, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (13, 5, 'admin', '节点管理', 'fa fa-fw fa-bars', 'module_admin', 'admin/menu/index', '_self', 0, 1467619882, 1477710695, 3, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (14, 13, 'admin', '新增', '', 'module_admin', 'admin/menu/add', '_self', 0, 1467619902, 1477710695, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (15, 13, 'admin', '编辑', '', 'module_admin', 'admin/menu/edit', '_self', 0, 1467620331, 1477710695, 2, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (16, 13, 'admin', '删除', '', 'module_admin', 'admin/menu/delete', '_self', 0, 1467620363, 1477710695, 3, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (17, 13, 'admin', '启用', '', 'module_admin', 'admin/menu/enable', '_self', 0, 1467620386, 1477710695, 4, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (18, 13, 'admin', '禁用', '', 'module_admin', 'admin/menu/disable', '_self', 0, 1467620404, 1477710695, 5, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (19, 68, 'user', '权限管理', 'fa fa-fw fa-key', 'module_admin', '', '_self', 0, 1467688065, 1477710702, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (20, 19, 'user', '用户管理', 'fa fa-fw fa-user', 'module_admin', 'user/index/index', '_self', 0, 1467688137, 1477710702, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (21, 20, 'user', '新增', '', 'module_admin', 'user/index/add', '_self', 0, 1467688177, 1477710702, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (22, 20, 'user', '编辑', '', 'module_admin', 'user/index/edit', '_self', 0, 1467688202, 1477710702, 2, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (23, 20, 'user', '删除', '', 'module_admin', 'user/index/delete', '_self', 0, 1467688219, 1477710702, 3, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (24, 20, 'user', '启用', '', 'module_admin', 'user/index/enable', '_self', 0, 1467688238, 1477710702, 4, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (25, 20, 'user', '禁用', '', 'module_admin', 'user/index/disable', '_self', 0, 1467688256, 1477710702, 5, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (211, 64, 'admin', '日志详情', '', 'module_admin', 'admin/log/details', '_self', 0, 1480299320, 1480299320, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (32, 4, 'admin', '扩展中心', 'si si-social-dropbox', 'module_admin', '', '_self', 0, 1467688853, 1477710695, 2, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (33, 32, 'admin', '模块管理', 'fa fa-fw fa-th-large', 'module_admin', 'admin/module/index', '_self', 0, 1467689008, 1477710695, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (34, 33, 'admin', '导入', '', 'module_admin', 'admin/module/import', '_self', 0, 1467689153, 1477710695, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (35, 33, 'admin', '导出', '', 'module_admin', 'admin/module/export', '_self', 0, 1467689173, 1477710695, 2, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (36, 33, 'admin', '安装', '', 'module_admin', 'admin/module/install', '_self', 0, 1467689192, 1477710695, 3, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (37, 33, 'admin', '卸载', '', 'module_admin', 'admin/module/uninstall', '_self', 0, 1467689241, 1477710695, 4, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (38, 33, 'admin', '启用', '', 'module_admin', 'admin/module/enable', '_self', 0, 1467689294, 1477710695, 5, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (39, 33, 'admin', '禁用', '', 'module_admin', 'admin/module/disable', '_self', 0, 1467689312, 1477710695, 6, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (40, 33, 'admin', '更新', '', 'module_admin', 'admin/module/update', '_self', 0, 1467689341, 1477710695, 7, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (41, 32, 'admin', '插件管理', 'fa fa-fw fa-puzzle-piece', 'module_admin', 'admin/plugin/index', '_self', 0, 1467689527, 1477710695, 2, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (42, 41, 'admin', '导入', '', 'module_admin', 'admin/plugin/import', '_self', 0, 1467689650, 1477710695, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (43, 41, 'admin', '导出', '', 'module_admin', 'admin/plugin/export', '_self', 0, 1467689665, 1477710695, 2, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (44, 41, 'admin', '安装', '', 'module_admin', 'admin/plugin/install', '_self', 0, 1467689680, 1477710695, 3, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (45, 41, 'admin', '卸载', '', 'module_admin', 'admin/plugin/uninstall', '_self', 0, 1467689700, 1477710695, 4, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (46, 41, 'admin', '启用', '', 'module_admin', 'admin/plugin/enable', '_self', 0, 1467689730, 1477710695, 5, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (47, 41, 'admin', '禁用', '', 'module_admin', 'admin/plugin/disable', '_self', 0, 1467689747, 1477710695, 6, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (48, 41, 'admin', '设置', '', 'module_admin', 'admin/plugin/config', '_self', 0, 1467689789, 1477710695, 7, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (49, 41, 'admin', '管理', '', 'module_admin', 'admin/plugin/manage', '_self', 0, 1467689846, 1477710695, 8, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (50, 5, 'admin', '附件管理', 'fa fa-fw fa-cloud-upload', 'module_admin', 'admin/attachment/index', '_self', 0, 1467690161, 1477710695, 4, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (51, 70, 'admin', '文件上传', '', 'module_admin', 'admin/attachment/upload', '_self', 0, 1467690240, 1489049773, 1, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (52, 50, 'admin', '下载', '', 'module_admin', 'admin/attachment/download', '_self', 0, 1467690334, 1477710695, 2, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (53, 50, 'admin', '启用', '', 'module_admin', 'admin/attachment/enable', '_self', 0, 1467690352, 1477710695, 3, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (54, 50, 'admin', '禁用', '', 'module_admin', 'admin/attachment/disable', '_self', 0, 1467690369, 1477710695, 4, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (55, 50, 'admin', '删除', '', 'module_admin', 'admin/attachment/delete', '_self', 0, 1467690396, 1477710695, 5, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (56, 41, 'admin', '删除', '', 'module_admin', 'admin/plugin/delete', '_self', 0, 1467858065, 1477710695, 11, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (57, 41, 'admin', '编辑', '', 'module_admin', 'admin/plugin/edit', '_self', 0, 1467858092, 1477710695, 10, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (60, 41, 'admin', '新增', '', 'module_admin', 'admin/plugin/add', '_self', 0, 1467858421, 1477710695, 9, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (61, 41, 'admin', '执行', '', 'module_admin', 'admin/plugin/execute', '_self', 0, 1467879016, 1477710695, 14, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (62, 13, 'admin', '保存', '', 'module_admin', 'admin/menu/save', '_self', 0, 1468073039, 1477710695, 6, 1, 1, '');
INSERT INTO `dp_admin_menu` VALUES (64, 5, 'admin', '系统日志', 'fa fa-fw fa-book', 'module_admin', 'admin/log/index', '_self', 0, 1476111944, 1477710695, 6, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (65, 5, 'admin', '数据库管理', 'fa fa-fw fa-database', 'module_admin', 'admin/database/index', '_self', 0, 1476111992, 1477710695, 8, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (66, 32, 'admin', '数据包管理', 'fa fa-fw fa-database', 'module_admin', 'admin/packet/index', '_self', 0, 1476112326, 1477710695, 4, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (67, 19, 'user', '角色管理', 'fa fa-fw fa-users', 'module_admin', 'user/role/index', '_self', 0, 1476113025, 1477710702, 3, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (68, 0, 'user', '用户', 'fa fa-fw fa-user', 'module_admin', 'user/index/index', '_self', 0, 1476193348, 1477710540, 3, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (69, 32, 'admin', '钩子管理', 'fa fa-fw fa-anchor', 'module_admin', 'admin/hook/index', '_self', 0, 1476236193, 1477710695, 3, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (70, 2, 'admin', '后台首页', 'fa fa-fw fa-tachometer', 'module_admin', 'admin/index/index', '_self', 0, 1476237472, 1489049773, 1, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (71, 67, 'user', '新增', '', 'module_admin', 'user/role/add', '_self', 0, 1476256935, 1477710702, 1, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (72, 67, 'user', '编辑', '', 'module_admin', 'user/role/edit', '_self', 0, 1476256968, 1477710702, 2, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (73, 67, 'user', '删除', '', 'module_admin', 'user/role/delete', '_self', 0, 1476256993, 1477710702, 3, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (74, 67, 'user', '启用', '', 'module_admin', 'user/role/enable', '_self', 0, 1476257023, 1477710702, 4, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (75, 67, 'user', '禁用', '', 'module_admin', 'user/role/disable', '_self', 0, 1476257046, 1477710702, 5, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (76, 20, 'user', '授权', '', 'module_admin', 'user/index/access', '_self', 0, 1476375187, 1477710702, 6, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (77, 69, 'admin', '新增', '', 'module_admin', 'admin/hook/add', '_self', 0, 1476668971, 1477710695, 1, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (78, 69, 'admin', '编辑', '', 'module_admin', 'admin/hook/edit', '_self', 0, 1476669006, 1477710695, 2, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (79, 69, 'admin', '删除', '', 'module_admin', 'admin/hook/delete', '_self', 0, 1476669375, 1477710695, 3, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (80, 69, 'admin', '启用', '', 'module_admin', 'admin/hook/enable', '_self', 0, 1476669427, 1477710695, 4, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (81, 69, 'admin', '禁用', '', 'module_admin', 'admin/hook/disable', '_self', 0, 1476669564, 1477710695, 5, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (183, 66, 'admin', '安装', '', 'module_admin', 'admin/packet/install', '_self', 0, 1476851362, 1477710695, 1, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (184, 66, 'admin', '卸载', '', 'module_admin', 'admin/packet/uninstall', '_self', 0, 1476851382, 1477710695, 2, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (185, 5, 'admin', '行为管理', 'fa fa-fw fa-bug', 'module_admin', 'admin/action/index', '_self', 0, 1476882441, 1477710695, 7, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (186, 185, 'admin', '新增', '', 'module_admin', 'admin/action/add', '_self', 0, 1476884439, 1477710695, 1, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (187, 185, 'admin', '编辑', '', 'module_admin', 'admin/action/edit', '_self', 0, 1476884464, 1477710695, 2, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (188, 185, 'admin', '启用', '', 'module_admin', 'admin/action/enable', '_self', 0, 1476884493, 1477710695, 3, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (189, 185, 'admin', '禁用', '', 'module_admin', 'admin/action/disable', '_self', 0, 1476884534, 1477710695, 4, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (190, 185, 'admin', '删除', '', 'module_admin', 'admin/action/delete', '_self', 0, 1476884551, 1477710695, 5, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (191, 65, 'admin', '备份数据库', '', 'module_admin', 'admin/database/export', '_self', 0, 1476972746, 1477710695, 1, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (192, 65, 'admin', '还原数据库', '', 'module_admin', 'admin/database/import', '_self', 0, 1476972772, 1477710695, 2, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (193, 65, 'admin', '优化表', '', 'module_admin', 'admin/database/optimize', '_self', 0, 1476972800, 1477710695, 3, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (194, 65, 'admin', '修复表', '', 'module_admin', 'admin/database/repair', '_self', 0, 1476972825, 1477710695, 4, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (195, 65, 'admin', '删除备份', '', 'module_admin', 'admin/database/delete', '_self', 0, 1476973457, 1477710695, 5, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (210, 41, 'admin', '快速编辑', '', 'module_admin', 'admin/plugin/quickedit', '_self', 0, 1477713981, 1477713981, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (209, 185, 'admin', '快速编辑', '', 'module_admin', 'admin/action/quickedit', '_self', 0, 1477713939, 1477713939, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (208, 7, 'admin', '快速编辑', '', 'module_admin', 'admin/config/quickedit', '_self', 0, 1477713808, 1477713808, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (207, 69, 'admin', '快速编辑', '', 'module_admin', 'admin/hook/quickedit', '_self', 0, 1477713770, 1477713770, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (212, 2, 'admin', '个人设置', 'fa fa-fw fa-user', 'module_admin', 'admin/index/profile', '_self', 0, 1489049767, 1489049773, 2, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (213, 70, 'admin', '检查版本更新', '', 'module_admin', 'admin/index/checkupdate', '_self', 0, 1490588610, 1490588610, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (214, 68, 'user', '消息管理', 'fa fa-fw fa-comments-o', 'module_admin', '', '_self', 0, 1520492129, 1520492129, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (215, 214, 'user', '消息列表', 'fa fa-fw fa-th-list', 'module_admin', 'user/message/index', '_self', 0, 1520492195, 1520492195, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (216, 215, 'user', '新增', '', 'module_admin', 'user/message/add', '_self', 0, 1520492195, 1520492195, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (217, 215, 'user', '编辑', '', 'module_admin', 'user/message/edit', '_self', 0, 1520492195, 1520492195, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (218, 215, 'user', '删除', '', 'module_admin', 'user/message/delete', '_self', 0, 1520492195, 1520492195, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (219, 215, 'user', '启用', '', 'module_admin', 'user/message/enable', '_self', 0, 1520492195, 1520492195, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (220, 215, 'user', '禁用', '', 'module_admin', 'user/message/disable', '_self', 0, 1520492195, 1520492195, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (221, 215, 'user', '快速编辑', '', 'module_admin', 'user/message/quickedit', '_self', 0, 1520492195, 1520492195, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (222, 2, 'admin', '消息中心', 'fa fa-fw fa-comments-o', 'module_admin', 'admin/message/index', '_self', 0, 1520495992, 1520496254, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (223, 222, 'admin', '删除', '', 'module_admin', 'admin/message/delete', '_self', 0, 1520495992, 1520496263, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (224, 222, 'admin', '启用', '', 'module_admin', 'admin/message/enable', '_self', 0, 1520495992, 1520496270, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (225, 32, 'admin', '图标管理', 'fa fa-fw fa-tint', 'module_admin', 'admin/icon/index', '_self', 0, 1520908295, 1520908295, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (226, 225, 'admin', '新增', '', 'module_admin', 'admin/icon/add', '_self', 0, 1520908295, 1520908295, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (227, 225, 'admin', '编辑', '', 'module_admin', 'admin/icon/edit', '_self', 0, 1520908295, 1520908295, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (228, 225, 'admin', '删除', '', 'module_admin', 'admin/icon/delete', '_self', 0, 1520908295, 1520908295, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (229, 225, 'admin', '启用', '', 'module_admin', 'admin/icon/enable', '_self', 0, 1520908295, 1520908295, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (230, 225, 'admin', '禁用', '', 'module_admin', 'admin/icon/disable', '_self', 0, 1520908295, 1520908295, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (231, 225, 'admin', '快速编辑', '', 'module_admin', 'admin/icon/quickedit', '_self', 0, 1520908295, 1520908295, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (232, 225, 'admin', '图标列表', '', 'module_admin', 'admin/icon/items', '_self', 0, 1520923368, 1520923368, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (233, 225, 'admin', '更新图标', '', 'module_admin', 'admin/icon/reload', '_self', 0, 1520931908, 1520931908, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (234, 20, 'user', '快速编辑', '', 'module_admin', 'user/index/quickedit', '_self', 0, 1526028258, 1526028258, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (235, 67, 'user', '快速编辑', '', 'module_admin', 'user/role/quickedit', '_self', 0, 1526028282, 1526028282, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (236, 0, 'cms', '门户', 'fa fa-fw fa-newspaper-o', 'module_admin', 'cms/index/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (237, 236, 'cms', '常用操作', 'fa fa-fw fa-folder-open-o', 'module_admin', '', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (238, 237, 'cms', '仪表盘', 'fa fa-fw fa-tachometer', 'module_admin', 'cms/index/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (239, 237, 'cms', '发布文档', 'fa fa-fw fa-plus', 'module_admin', 'cms/document/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (240, 237, 'cms', '文档列表', 'fa fa-fw fa-list', 'module_admin', 'cms/document/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (241, 240, 'cms', '编辑', '', 'module_admin', 'cms/document/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (242, 240, 'cms', '删除', '', 'module_admin', 'cms/document/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (243, 240, 'cms', '启用', '', 'module_admin', 'cms/document/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (244, 240, 'cms', '禁用', '', 'module_admin', 'cms/document/disable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (245, 240, 'cms', '快速编辑', '', 'module_admin', 'cms/document/quickedit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (246, 237, 'cms', '单页管理', 'fa fa-fw fa-file-word-o', 'module_admin', 'cms/page/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (247, 246, 'cms', '新增', '', 'module_admin', 'cms/page/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (248, 246, 'cms', '编辑', '', 'module_admin', 'cms/page/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (249, 246, 'cms', '删除', '', 'module_admin', 'cms/page/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (250, 246, 'cms', '启用', '', 'module_admin', 'cms/page/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (251, 246, 'cms', '禁用', '', 'module_admin', 'cms/page/disable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (252, 246, 'cms', '快速编辑', '', 'module_admin', 'cms/page/quickedit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (253, 237, 'cms', '回收站', 'fa fa-fw fa-recycle', 'module_admin', 'cms/recycle/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (254, 253, 'cms', '删除', '', 'module_admin', 'cms/recycle/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (255, 253, 'cms', '还原', '', 'module_admin', 'cms/recycle/restore', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (256, 236, 'cms', '内容管理', 'fa fa-fw fa-th-list', 'module_admin', '', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (257, 236, 'cms', '营销管理', 'fa fa-fw fa-money', 'module_admin', '', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (258, 257, 'cms', '广告管理', 'fa fa-fw fa-handshake-o', 'module_admin', 'cms/advert/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (259, 258, 'cms', '新增', '', 'module_admin', 'cms/advert/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (260, 258, 'cms', '编辑', '', 'module_admin', 'cms/advert/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (261, 258, 'cms', '删除', '', 'module_admin', 'cms/advert/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (262, 258, 'cms', '启用', '', 'module_admin', 'cms/advert/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (263, 258, 'cms', '禁用', '', 'module_admin', 'cms/advert/disable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (264, 258, 'cms', '快速编辑', '', 'module_admin', 'cms/advert/quickedit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (265, 258, 'cms', '广告分类', '', 'module_admin', 'cms/advert_type/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (266, 265, 'cms', '新增', '', 'module_admin', 'cms/advert_type/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (267, 265, 'cms', '编辑', '', 'module_admin', 'cms/advert_type/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (268, 265, 'cms', '删除', '', 'module_admin', 'cms/advert_type/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (269, 265, 'cms', '启用', '', 'module_admin', 'cms/advert_type/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (270, 265, 'cms', '禁用', '', 'module_admin', 'cms/advert_type/disable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (271, 265, 'cms', '快速编辑', '', 'module_admin', 'cms/advert_type/quickedit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (272, 257, 'cms', '滚动图片', 'fa fa-fw fa-photo', 'module_admin', 'cms/slider/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (273, 272, 'cms', '新增', '', 'module_admin', 'cms/slider/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (274, 272, 'cms', '编辑', '', 'module_admin', 'cms/slider/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (275, 272, 'cms', '删除', '', 'module_admin', 'cms/slider/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (276, 272, 'cms', '启用', '', 'module_admin', 'cms/slider/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (277, 272, 'cms', '禁用', '', 'module_admin', 'cms/slider/disable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (278, 272, 'cms', '快速编辑', '', 'module_admin', 'cms/slider/quickedit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (279, 257, 'cms', '友情链接', 'fa fa-fw fa-link', 'module_admin', 'cms/link/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (280, 279, 'cms', '新增', '', 'module_admin', 'cms/link/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (281, 279, 'cms', '编辑', '', 'module_admin', 'cms/link/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (282, 279, 'cms', '删除', '', 'module_admin', 'cms/link/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (283, 279, 'cms', '启用', '', 'module_admin', 'cms/link/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (284, 279, 'cms', '禁用', '', 'module_admin', 'cms/link/disable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (285, 279, 'cms', '快速编辑', '', 'module_admin', 'cms/link/quickedit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (286, 257, 'cms', '客服管理', 'fa fa-fw fa-commenting', 'module_admin', 'cms/support/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (287, 286, 'cms', '新增', '', 'module_admin', 'cms/support/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (288, 286, 'cms', '编辑', '', 'module_admin', 'cms/support/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (289, 286, 'cms', '删除', '', 'module_admin', 'cms/support/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (290, 286, 'cms', '启用', '', 'module_admin', 'cms/support/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (291, 286, 'cms', '禁用', '', 'module_admin', 'cms/support/disable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (292, 286, 'cms', '快速编辑', '', 'module_admin', 'cms/support/quickedit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (293, 236, 'cms', '门户设置', 'fa fa-fw fa-sliders', 'module_admin', '', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (294, 293, 'cms', '栏目分类', 'fa fa-fw fa-sitemap', 'module_admin', 'cms/column/index', '_self', 1, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (295, 294, 'cms', '新增', '', 'module_admin', 'cms/column/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (296, 294, 'cms', '编辑', '', 'module_admin', 'cms/column/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (297, 294, 'cms', '删除', '', 'module_admin', 'cms/column/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (298, 294, 'cms', '启用', '', 'module_admin', 'cms/column/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (299, 294, 'cms', '禁用', '', 'module_admin', 'cms/column/disable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (300, 294, 'cms', '快速编辑', '', 'module_admin', 'cms/column/quickedit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (301, 293, 'cms', '内容模型', 'fa fa-fw fa-th-large', 'module_admin', 'cms/model/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (302, 301, 'cms', '新增', '', 'module_admin', 'cms/model/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (303, 301, 'cms', '编辑', '', 'module_admin', 'cms/model/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (304, 301, 'cms', '删除', '', 'module_admin', 'cms/model/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (305, 301, 'cms', '启用', '', 'module_admin', 'cms/model/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (306, 301, 'cms', '禁用', '', 'module_admin', 'cms/model/disable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (307, 301, 'cms', '快速编辑', '', 'module_admin', 'cms/model/quickedit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (308, 301, 'cms', '字段管理', '', 'module_admin', 'cms/field/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (309, 308, 'cms', '新增', '', 'module_admin', 'cms/field/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (310, 308, 'cms', '编辑', '', 'module_admin', 'cms/field/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (311, 308, 'cms', '删除', '', 'module_admin', 'cms/field/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (312, 308, 'cms', '启用', '', 'module_admin', 'cms/field/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (313, 308, 'cms', '禁用', '', 'module_admin', 'cms/field/disable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (314, 308, 'cms', '快速编辑', '', 'module_admin', 'cms/field/quickedit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (315, 293, 'cms', '导航管理', 'fa fa-fw fa-map-signs', 'module_admin', 'cms/nav/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (316, 315, 'cms', '新增', '', 'module_admin', 'cms/nav/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (317, 315, 'cms', '编辑', '', 'module_admin', 'cms/nav/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (318, 315, 'cms', '删除', '', 'module_admin', 'cms/nav/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (319, 315, 'cms', '启用', '', 'module_admin', 'cms/nav/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (320, 315, 'cms', '禁用', '', 'module_admin', 'cms/nav/disable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (321, 315, 'cms', '快速编辑', '', 'module_admin', 'cms/nav/quickedit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (322, 315, 'cms', '菜单管理', '', 'module_admin', 'cms/menu/index', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (323, 322, 'cms', '新增', '', 'module_admin', 'cms/menu/add', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (324, 322, 'cms', '编辑', '', 'module_admin', 'cms/menu/edit', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (325, 322, 'cms', '删除', '', 'module_admin', 'cms/menu/delete', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (326, 322, 'cms', '启用', '', 'module_admin', 'cms/menu/enable', '_self', 0, 1530582238, 1530582238, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (327, 322, 'cms', '禁用', '', 'module_admin', 'cms/menu/disable', '_self', 0, 1530582239, 1530582239, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (328, 322, 'cms', '快速编辑', '', 'module_admin', 'cms/menu/quickedit', '_self', 0, 1530582239, 1530582239, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (329, 0, 'crontab', '定时任务', 'glyphicon glyphicon-time', 'module_admin', 'crontab/index/index', '_self', 0, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (330, 329, 'crontab', '任务列表', 'fa fa-fw fa-list', 'module_admin', 'crontab/index/index', '_self', 0, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (331, 330, 'crontab', '禁用', '', 'module_admin', 'crontab/index/disable', '_self', 1, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (332, 330, 'crontab', '编辑', '', 'module_admin', 'crontab/index/edit', '_self', 1, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (333, 330, 'crontab', '删除', '', 'module_admin', 'crontab/index/delete', '_self', 1, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (334, 330, 'crontab', '添加', '', 'module_admin', 'crontab/index/add', '_self', 1, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (335, 330, 'crontab', '启用', '', 'module_admin', 'crontab/index/enable', '_self', 1, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (336, 330, 'crontab', '检查Crontab格式', '', 'module_admin', 'crontab/index/checkschedule', '_self', 1, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (337, 330, 'crontab', '获取未来N次的时间', '', 'module_admin', 'crontab/index/getschedulefuture', '_self', 1, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (338, 329, 'crontab', '执行日志', 'fa fa-fw fa-play', 'module_admin', 'crontab/log/index', '_self', 0, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (339, 338, 'crontab', '编辑', '', 'module_admin', 'crontab/log/edit', '_self', 1, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (340, 338, 'crontab', '清空日志', '', 'module_admin', 'crontab/log/clear', '_self', 1, 1530582248, 1530582248, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (341, 0, 'wechat', '微信', 'fa fa-fw fa-newspaper-o', 'module_admin', 'wechat/index/index', '_self', 0, 1530583858, 1530583858, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (342, 341, 'wechat', '配置管理', 'fa fa-fw fa-folder-open-o', 'module_admin', '', '_self', 0, 1530583858, 1530583858, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (343, 342, 'wechat', '商户配置', 'fa fa-fw fa-tachometer', 'module_admin', 'wechat/config/merchant', '_self', 0, 1530583858, 1530583858, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (344, 342, 'wechat', '小程序配置', 'fa fa-fw fa-plus', 'module_admin', 'wechat/config/miniapp', '_self', 0, 1530583858, 1530583858, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (345, 342, 'wechat', 'APP配置', 'fa fa-fw fa-list', 'module_admin', 'wechat/config/weapp', '_self', 0, 1530583858, 1530583858, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (346, 342, 'wechat', '公众号配置', 'fa fa-fw fa-file-word-o', 'module_admin', 'wechat/config/index', '_self', 0, 1530583858, 1530583858, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (347, 0, 'member', '林主管理', 'fa fa-fw fa-newspaper-o', 'module_admin', 'member/index/index', '_self', 0, 1530590329, 1530590329, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (348, 347, 'member', '林主管理', 'fa fa-fw fa-folder-open-o', 'module_admin', '', '_self', 0, 1530590329, 1530590329, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (349, 348, 'member', '林主列表', 'fa fa-fw fa-tachometer', 'module_admin', 'member/index/index', '_self', 0, 1530590329, 1530590329, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (380, 378, 'groupbuy', '编辑', '', 'module_admin', 'groupbuy/category/edit', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (381, 378, 'groupbuy', '删除', '', 'module_admin', 'groupbuy/category/delete', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (379, 378, 'groupbuy', '添加', '', 'module_admin', 'groupbuy/category/add', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (378, 370, 'groupbuy', '分类管理', 'fa fa-fw fa-plus', 'module_admin', 'groupbuy/category/index', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (377, 371, 'groupbuy', '快速编辑', '', 'module_admin', 'groupbuy/product/quickedit', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (376, 371, 'groupbuy', '禁用', '', 'module_admin', 'groupbuy/product/disable', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (375, 371, 'groupbuy', '启用', '', 'module_admin', 'groupbuy/product/enable', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (374, 371, 'groupbuy', '删除', '', 'module_admin', 'groupbuy/product/delete', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (373, 371, 'groupbuy', '编辑', '', 'module_admin', 'groupbuy/product/edit', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (372, 371, 'groupbuy', '添加', '', 'module_admin', 'groupbuy/product/add', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (371, 370, 'groupbuy', '商品管理', 'fa fa-fw fa-tachometer', 'module_admin', 'groupbuy/product/index', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (370, 369, 'groupbuy', '团购', 'fa fa-fw fa-folder-open-o', 'module_admin', '', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (369, 0, 'groupbuy', '团购', 'fa fa-fw fa-newspaper-o', 'module_admin', 'groupbuy/product/index', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (382, 378, 'groupbuy', '启用', '', 'module_admin', 'groupbuy/category/enable', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (383, 378, 'groupbuy', '禁用', '', 'module_admin', 'groupbuy/category/disable', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
INSERT INTO `dp_admin_menu` VALUES (384, 378, 'groupbuy', '快速编辑', '', 'module_admin', 'groupbuy/category/quickedit', '_self', 0, 1530671067, 1530671067, 100, 0, 1, '');
COMMIT;

-- ----------------------------
-- Table structure for dp_admin_message
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_message`;
CREATE TABLE `dp_admin_message` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid_receive` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '接收消息的用户id',
  `uid_send` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发送消息的用户id',
  `type` varchar(128) NOT NULL DEFAULT '' COMMENT '消息分类',
  `content` text NOT NULL COMMENT '消息内容',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `read_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '阅读时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='消息表';

-- ----------------------------
-- Table structure for dp_admin_module
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_module`;
CREATE TABLE `dp_admin_module` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '模块名称（标识）',
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '模块标题',
  `icon` varchar(64) NOT NULL DEFAULT '' COMMENT '图标',
  `description` text NOT NULL COMMENT '描述',
  `author` varchar(32) NOT NULL DEFAULT '' COMMENT '作者',
  `author_url` varchar(255) NOT NULL DEFAULT '' COMMENT '作者主页',
  `config` text COMMENT '配置信息',
  `access` text COMMENT '授权配置',
  `version` varchar(16) NOT NULL DEFAULT '' COMMENT '版本号',
  `identifier` varchar(64) NOT NULL DEFAULT '' COMMENT '模块唯一标识符',
  `system_module` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否为系统模块',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='模块表';

-- ----------------------------
-- Records of dp_admin_module
-- ----------------------------
BEGIN;
INSERT INTO `dp_admin_module` VALUES (1, 'admin', '系统', 'fa fa-fw fa-gear', '系统模块，DolphinPHP的核心模块', 'DolphinPHP', 'http://www.dolphinphp.com', '', '', '1.0.0', 'admin.dolphinphp.module', 1, 1468204902, 1468204902, 100, 1);
INSERT INTO `dp_admin_module` VALUES (2, 'user', '用户', 'fa fa-fw fa-user', '用户模块，DolphinPHP自带模块', 'DolphinPHP', 'http://www.dolphinphp.com', '', '', '1.0.0', 'user.dolphinphp.module', 1, 1468204902, 1468204902, 100, 1);
INSERT INTO `dp_admin_module` VALUES (3, 'cms', '门户', 'fa fa-fw fa-newspaper-o', '门户模块', 'CaiWeiMing', 'http://www.dolphinphp.com', '{\"summary\":0,\"contact\":\"<div class=\\\"font-s13 push\\\"><strong>\\u6cb3\\u6e90\\u5e02\\u5353\\u9510\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8<\\/strong><br \\/>\\n\\u5730\\u5740\\uff1a\\u6cb3\\u6e90\\u5e02\\u6c5f\\u4e1c\\u65b0\\u533a\\u4e1c\\u73af\\u8def\\u6c47\\u901a\\u82d1D3-H232<br \\/>\\n\\u7535\\u8bdd\\uff1a0762-8910006<br \\/>\\n\\u90ae\\u7bb1\\uff1aadmin@zrthink.com<\\/div>\",\"meta_head\":\"\",\"meta_foot\":\"\",\"support_status\":1,\"support_color\":\"rgba(0,158,232,1)\",\"support_wx\":\"\",\"support_extra\":\"\"}', '{\"group\":{\"tab_title\":\"\\u680f\\u76ee\\u6388\\u6743\",\"table_name\":\"cms_column\",\"primary_key\":\"id\",\"parent_id\":\"pid\",\"node_name\":\"name\"}}', '1.0.0', 'cms.ming.module', 0, 1530582239, 1530582239, 100, 1);
INSERT INTO `dp_admin_module` VALUES (4, 'crontab', '定时任务', 'glyphicon glyphicon-time', '模块依赖 composer 组件 <code>mtdowling/cron-expression</code> 和 <code>guzzlehttp/guzzle</code>', '流风回雪', 'http://www.dolphinphp.com/', NULL, NULL, '1.0.0', 'crontab.meishixiu.module', 0, 1530582248, 1530582248, 100, 1);
INSERT INTO `dp_admin_module` VALUES (5, 'wechat', '微信支持', 'fa fa-fw fa-newspaper-o', '管理所有微信相关，app,小程序，公众号等', 'Dragonlhp', '', '{\"mch_id\":\"1502434241\",\"mch_key\":\"mtYWcTfRfUsUJnYHKIuiZlWXoljwcHmN\",\"officialAccount_app_id\":\"\",\"officialAccount_secret\":\"\",\"miniProgram_app_id\":\"wx563f7fa8f406d31a\",\"miniProgram_secret\":\"29c76c0f35544400efc88f24f8e42213\",\"openPlatform_app_id\":\"\",\"openPlatform_secret\":\"\",\"openPlatform_token\":\"\",\"openPlatform_aes_key\":\"\"}', '', '1.0.0', 'wechat.ming.module', 0, 1530583858, 1530584948, 100, 1);
INSERT INTO `dp_admin_module` VALUES (6, 'member', '林主管理', 'fa fa-fw fa-newspaper-o', '时间林林主管理模块', 'Dragonlhp', '', NULL, NULL, '1.0.0', 'member.dragonlhp.module', 0, 1530590329, 1530590329, 100, 1);
INSERT INTO `dp_admin_module` VALUES (9, 'groupbuy', '团购', 'fa fa-fw fa-newspaper-o', '管理所有微信相关，app,小程序，公众号等', 'Dragonlhp', '', NULL, NULL, '1.0.0', 'groupbuy.dragonlhp.module', 0, 1530671067, 1530671067, 100, 1);
COMMIT;

-- ----------------------------
-- Table structure for dp_admin_packet
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_packet`;
CREATE TABLE `dp_admin_packet` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '数据包名',
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '数据包标题',
  `author` varchar(32) NOT NULL DEFAULT '' COMMENT '作者',
  `author_url` varchar(255) NOT NULL DEFAULT '' COMMENT '作者url',
  `version` varchar(16) NOT NULL,
  `tables` text NOT NULL COMMENT '数据表名',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='数据包表';

-- ----------------------------
-- Table structure for dp_admin_plugin
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_plugin`;
CREATE TABLE `dp_admin_plugin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '插件名称',
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '插件标题',
  `icon` varchar(64) NOT NULL DEFAULT '' COMMENT '图标',
  `description` text NOT NULL COMMENT '插件描述',
  `author` varchar(32) NOT NULL DEFAULT '' COMMENT '作者',
  `author_url` varchar(255) NOT NULL DEFAULT '' COMMENT '作者主页',
  `config` text NOT NULL COMMENT '配置信息',
  `version` varchar(16) NOT NULL DEFAULT '' COMMENT '版本号',
  `identifier` varchar(64) NOT NULL DEFAULT '' COMMENT '插件唯一标识符',
  `admin` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否有后台管理',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '安装时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='插件表';

-- ----------------------------
-- Records of dp_admin_plugin
-- ----------------------------
BEGIN;
INSERT INTO `dp_admin_plugin` VALUES (1, 'SystemInfo', '系统环境信息', 'fa fa-fw fa-info-circle', '在后台首页显示服务器信息', '蔡伟明', 'http://www.caiweiming.com', '{\"display\":\"1\",\"width\":\"6\"}', '1.0.0', 'system_info.ming.plugin', 0, 1477757503, 1477757503, 100, 1);
INSERT INTO `dp_admin_plugin` VALUES (2, 'DevTeam', '开发团队成员信息', 'fa fa-fw fa-users', '开发团队成员信息', '蔡伟明', 'http://www.caiweiming.com', '{\"display\":\"1\",\"width\":\"6\"}', '1.0.0', 'dev_team.ming.plugin', 0, 1477755780, 1477755780, 100, 1);
INSERT INTO `dp_admin_plugin` VALUES (3, 'QiNiu', '七牛上传插件', 'fa fa-fw fa-upload', '仅支持DolphinPHP1.0.6以上版本，安装后，需将【<a href=\"/admin.php/admin/system/index/group/upload.html\">上传驱动</a>】将其设置为“七牛云”。在附件管理中删除文件，并不会同时删除七牛云上的文件。', '蔡伟明', 'http://www.caiweiming.com', '{\"ak\":\"PKlSlXoB2SMlWnx1LJvJzcLz0CQltJ2iysshcZtC\",\"sk\":\"s0WDiIYE6auPRVMJVqZjcR0eSPpz6kvK4rp7gvJV\",\"bucket\":\"timeappthree\",\"domain\":\"http:\\/\\/timeappthree.ssjtime.cn\\/\"}', '1.0.3', 'qi_niu.ming.plugin', 0, 1530582171, 1530582171, 100, 1);
INSERT INTO `dp_admin_plugin` VALUES (4, 'Sms', '短信插件', 'fa fa-fw fa-envelope-o', '阿里大鱼短信插件', '蔡伟明', 'http://www.dolphinphp.com', '{\"status\":1,\"appkey\":\"\",\"secret\":\"\"}', '1.0.0', 'sms.ming.plugin', 1, 1530582178, 1530582178, 100, 1);
INSERT INTO `dp_admin_plugin` VALUES (5, 'Excel', 'Excel 插件', 'fa fa-fw fa-file-excel-o', '导入或导出excel', '蔡伟明', 'http://www.caiweiming.com', '', '1.0.1', 'excel.ming.plugin', 0, 1530582184, 1530582184, 100, 1);
INSERT INTO `dp_admin_plugin` VALUES (6, 'TencentSms', '腾讯云短信发送插件', 'fa fa-fw fa-commenting', '腾讯云短信发送插件', 'dragonlhp', '', '{\"Appid\":\"1400036852\",\"Appkey\":\"9f6bd6ea9fbd14ddf28aca75c1d7be3b\"}', '1.0.0', 'tencentsms.dragonlhp.plugin', 0, 1530600835, 1530600835, 100, 1);
COMMIT;

-- ----------------------------
-- Table structure for dp_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_role`;
CREATE TABLE `dp_admin_role` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上级角色',
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '角色名称',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '角色描述',
  `menu_auth` text NOT NULL COMMENT '菜单权限',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  `access` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否可登录后台',
  `default_module` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '默认访问模块',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of dp_admin_role
-- ----------------------------
BEGIN;
INSERT INTO `dp_admin_role` VALUES (1, 0, '超级管理员', '系统默认创建的角色，拥有最高权限', '', 0, 1476270000, 1468117612, 1, 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for dp_admin_user
-- ----------------------------
DROP TABLE IF EXISTS `dp_admin_user`;
CREATE TABLE `dp_admin_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL DEFAULT '' COMMENT '用户名',
  `nickname` varchar(32) NOT NULL DEFAULT '' COMMENT '昵称',
  `password` varchar(96) NOT NULL DEFAULT '' COMMENT '密码',
  `email` varchar(64) NOT NULL DEFAULT '' COMMENT '邮箱地址',
  `email_bind` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否绑定邮箱地址',
  `mobile` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号码',
  `mobile_bind` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否绑定手机号码',
  `avatar` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '头像',
  `money` decimal(11,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '余额',
  `score` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
  `role` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '角色ID',
  `group` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '部门id',
  `signup_ip` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '注册ip',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `last_login_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后一次登录时间',
  `last_login_ip` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '登录ip',
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态：0禁用，1启用',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of dp_admin_user
-- ----------------------------
BEGIN;
INSERT INTO `dp_admin_user` VALUES (1, 'admin', '超级管理员', '$2y$10$m41KHeZDZgLcdH03lb9CquzZ5YMMFoaJ0bQnVgbwyh1DGSOXGaUAu', '', 0, '', 0, 0, 0.00, 0, 1, 0, 0, 1476065410, 1530516102, 1530516077, 0, 100, 1);
COMMIT;

-- ----------------------------
-- Table structure for dp_base_buyrecord
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_buyrecord`;
CREATE TABLE `dp_base_buyrecord` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` varchar(50) NOT NULL COMMENT '用户id',
  `order_sn` varchar(50) NOT NULL COMMENT '订单编号',
  `product_id` int(4) NOT NULL DEFAULT '0' COMMENT '时间林id',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总价',
  `price` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '单价',
  `procedure_price` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '手续费',
  `num` int(11) NOT NULL DEFAULT '0' COMMENT '数量',
  `buychat_id` int(11) NOT NULL COMMENT '买入托管id',
  `trade_type` enum('upward','last','tuangou') NOT NULL DEFAULT 'last' COMMENT '方向  买入  卖出',
  `trade_status` enum('ordernormal','orderoff') NOT NULL DEFAULT 'ordernormal' COMMENT '订单状态  正常 撤销',
  `sellchat_id` int(11) NOT NULL DEFAULT '0' COMMENT '卖出托管id',
  `create_time` int(11) NOT NULL COMMENT '时间',
  `trade_source` enum('app','miniProgram') NOT NULL COMMENT '交易来源(APP,APP程序，miniProgram小程序)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='交易记录表';

-- ----------------------------
-- Table structure for dp_base_category
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_category`;
CREATE TABLE `dp_base_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类ID',
  `pid` int(11) NOT NULL DEFAULT '0' COMMENT '父分类ID',
  `title` char(30) NOT NULL COMMENT '分类名称',
  `image` int(11) DEFAULT NULL COMMENT '分类图片',
  `status` tinyint(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dp_base_category
-- ----------------------------
BEGIN;
INSERT INTO `dp_base_category` VALUES (1, 0, '桐子树', 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for dp_base_goods_order
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_goods_order`;
CREATE TABLE `dp_base_goods_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单id',
  `order_sn` varchar(20) NOT NULL COMMENT '订单编号',
  `pay_sn` varchar(40) DEFAULT NULL COMMENT '回调单号',
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `amount` decimal(9,2) DEFAULT '0.00' COMMENT '价格',
  `addtime` int(10) NOT NULL DEFAULT '0' COMMENT '购买时间',
  `del` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除状态',
  `type` enum('weixin','alipay','cash') DEFAULT 'weixin' COMMENT '支付方式',
  `price_h` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '真实支付金额 是回调填入的\n',
  `status` tinyint(2) NOT NULL DEFAULT '10' COMMENT '订单状态{0,已取消10未付款20代发货30待收货40待评价50交易完成51交易关闭',
  `receiver` varchar(15) NOT NULL COMMENT '收货人',
  `tel` char(15) NOT NULL COMMENT '联系方式',
  `address_xq` varchar(50) NOT NULL COMMENT '地址详情',
  `code` int(11) NOT NULL COMMENT '邮编',
  `post` int(11) DEFAULT NULL COMMENT '快递ID',
  `remark` varchar(255) DEFAULT NULL COMMENT '买家留言',
  `post_remark` varchar(255) NOT NULL COMMENT '邮费信息',
  `product_num` int(11) NOT NULL DEFAULT '1' COMMENT '商品数量',
  `kuaidi_name` varchar(10) DEFAULT NULL COMMENT '快递名称',
  `kuaidi_num` varchar(20) DEFAULT NULL COMMENT '运单号',
  `order_type` tinyint(2) DEFAULT '1' COMMENT '订单类型 1团购订单 2商城订单',
  `paytime` int(10) NOT NULL COMMENT '支付时间',
  `order_addtime` int(10) NOT NULL COMMENT '收货时间',
  `pro_title` varchar(255) DEFAULT NULL COMMENT '商品标题',
  `pro_id` int(11) DEFAULT NULL COMMENT '商品ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单';

-- ----------------------------
-- Table structure for dp_base_goods_order_table
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_goods_order_table`;
CREATE TABLE `dp_base_goods_order_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单商品信息表',
  `pro_pid` int(11) NOT NULL DEFAULT '0' COMMENT '商品id',
  `order_id` int(11) NOT NULL DEFAULT '0' COMMENT '订单id',
  `pro_name` varchar(50) NOT NULL COMMENT '产品名称',
  `pro_prices` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT '价格',
  `pro_photos` varchar(100) DEFAULT NULL COMMENT '商品图',
  `addtime` int(11) NOT NULL COMMENT '添加时间',
  `num` int(11) NOT NULL DEFAULT '1' COMMENT '购买数量',
  `del` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除 默认0',
  `spec_key` varchar(100) NOT NULL COMMENT '规格id',
  `spec_key_name` varchar(200) NOT NULL COMMENT '规格名字',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单商品规格表';

-- ----------------------------
-- Table structure for dp_base_group_goods
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_group_goods`;
CREATE TABLE `dp_base_group_goods` (
  `id` int(10) NOT NULL,
  `pro_title` varchar(100) NOT NULL COMMENT '商品的标题',
  `pro_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品的现价格',
  `pro_yprice` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '商品的原价格',
  `pro_introduction` varchar(255) NOT NULL COMMENT '商品简介',
  `pro_details` text COMMENT '商品详情',
  `pro_specifications` int(5) NOT NULL DEFAULT '0' COMMENT '商品的规格',
  `pro_shiyong` int(10) DEFAULT '0' COMMENT '商品销量',
  `pro_status` int(2) DEFAULT '1' COMMENT '商品状态。1上架 2 下架 \n',
  `pro_sort` varchar(10) DEFAULT '0' COMMENT '商品排序',
  `pro_logo` varchar(255) DEFAULT '0' COMMENT '商品logo',
  `pro_photo` varchar(255) DEFAULT '0' COMMENT '商品图片',
  `pro_cover` varchar(255) DEFAULT '0' COMMENT '商品轮播图 图片的ID以，隔开',
  `addtime` int(10) DEFAULT '0' COMMENT '新增时间',
  `updatetime` int(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
  `pro_classification` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '所属分类1',
  `pro_classification2` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '所属分类2',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='团购商品表';

-- ----------------------------
-- Table structure for dp_base_log
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_log`;
CREATE TABLE `dp_base_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '日志',
  `text` text NOT NULL COMMENT '内容',
  `contro_find` varchar(255) NOT NULL COMMENT '控制器方法',
  `addtime` int(10) DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='行为日志';

-- ----------------------------
-- Table structure for dp_base_member
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_member`;
CREATE TABLE `dp_base_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` int(11) DEFAULT NULL COMMENT '手机号码',
  `password` varchar(64) DEFAULT NULL COMMENT '密码',
  `status` tinyint(2) DEFAULT NULL COMMENT '状态：0:禁用，1:启用',
  `create_time` int(11) DEFAULT NULL COMMENT '用户注册时间',
  `update_time` int(11) DEFAULT NULL COMMENT '用户更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dp_base_member
-- ----------------------------
BEGIN;
INSERT INTO `dp_base_member` VALUES (1, 2147483647, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for dp_base_member_info
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_member_info`;
CREATE TABLE `dp_base_member_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL COMMENT '用户ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for dp_base_member_wechat
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_member_wechat`;
CREATE TABLE `dp_base_member_wechat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `uniq_id` varchar(60) DEFAULT NULL COMMENT '同一个商户微信唯一ID',
  `nickName` char(60) DEFAULT NULL COMMENT '微信昵称',
  `avatarUrl` varchar(255) DEFAULT NULL COMMENT '头像地址',
  `officialAccount_open_id` char(60) DEFAULT NULL COMMENT '公众号OpenID',
  `miniProgram_open_id` char(60) DEFAULT NULL COMMENT '小程序OpenID',
  `app_open_id` char(60) DEFAULT NULL COMMENT 'APP程序微信OpenID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dp_base_member_wechat
-- ----------------------------
BEGIN;
INSERT INTO `dp_base_member_wechat` VALUES (1, 1, '1', 'paulli', NULL, '123', '123', '123');
COMMIT;

-- ----------------------------
-- Table structure for dp_base_prize_record
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_prize_record`;
CREATE TABLE `dp_base_prize_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `make_buyrecord_id` int(10) DEFAULT '0' COMMENT '购买记录id',
  `uid` varchar(64) DEFAULT NULL COMMENT '用户ID',
  `puid` varchar(64) DEFAULT NULL COMMENT '上一级UID',
  `prize` decimal(10,2) DEFAULT '0.00' COMMENT '奖励金额',
  `score` decimal(10,2) DEFAULT '0.00' COMMENT '积分',
  `from` tinyint(2) DEFAULT '0' COMMENT '1表示1级，2表示二级',
  `addtime` int(10) DEFAULT '0' COMMENT '增加时间',
  `buy_money` decimal(10,2) DEFAULT '0.00' COMMENT '购买金额',
  `user_phone` char(15) DEFAULT NULL COMMENT '用户手机号码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='团购奖励';

-- ----------------------------
-- Table structure for dp_base_product
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_product`;
CREATE TABLE `dp_base_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` int(11) DEFAULT NULL COMMENT '商品名称',
  `cid` int(11) DEFAULT NULL COMMENT '分类ID',
  `price` decimal(10,2) DEFAULT NULL COMMENT '价格',
  `inventory_num` int(11) DEFAULT NULL COMMENT '库存',
  `image` int(11) DEFAULT NULL COMMENT '商品封面',
  `images` int(11) DEFAULT NULL COMMENT '商品轮播图',
  `abstract` varchar(255) DEFAULT NULL COMMENT '产品简介',
  `details` text COMMENT '产品详情',
  `status` tinyint(2) DEFAULT NULL COMMENT '状态：0下架；1上架',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='商品表';

-- ----------------------------
-- Records of dp_base_product
-- ----------------------------
BEGIN;
INSERT INTO `dp_base_product` VALUES (1, 0, 1, 100.00, 100000, 1, 1, NULL, '<p><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%B1%B1%E6%A1%90%E5%AD%90\" style=\"color: rgb(19, 110, 194); text-decoration: underline; font-family: arial, 宋体, sans-serif; text-indent: 28px; white-space: normal; background-color: rgb(255, 255, 255); font-size: 20px;\"><span style=\"font-size: 20px;\">&nbsp;&nbsp;&nbsp;&nbsp;山桐子</span></a><span style=\"color: rgb(51, 51, 51); font-family: arial, 宋体, sans-serif; text-indent: 28px; background-color: rgb(255, 255, 255); font-size: 20px;\">是一种植物，别名椅、水冬瓜、水冬桐、椅树、椅桐、斗霜红，拉丁文名：Idesia polycarpa Maxim.，</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%A4%A7%E9%A3%8E%E5%AD%90%E7%A7%91\" style=\"color: rgb(19, 110, 194); text-decoration: underline; font-family: arial, 宋体, sans-serif; text-indent: 28px; white-space: normal; background-color: rgb(255, 255, 255); font-size: 20px;\"><span style=\"font-size: 20px;\">大风子科</span></a><span style=\"color: rgb(51, 51, 51); font-family: arial, 宋体, sans-serif; text-indent: 28px; background-color: rgb(255, 255, 255); font-size: 20px;\">、</span><a target=\"_blank\" href=\"https://baike.baidu.com/item/%E5%B1%B1%E6%A1%90%E5%AD%90%E5%B1%9E\" style=\"color: rgb(19, 110, 194); text-decoration: underline; font-family: arial, 宋体, sans-serif; text-indent: 28px; white-space: normal; background-color: rgb(255, 255, 255); font-size: 20px;\"><span style=\"font-size: 20px;\">山桐子属</span></a><span style=\"color: rgb(51, 51, 51); font-family: arial, 宋体, sans-serif; text-indent: 28px; background-color: rgb(255, 255, 255); font-size: 20px;\">落叶乔木，树皮淡灰色，不裂；小枝圆柱形，细而脆，黄棕色，有明显的皮孔，冬日呈侧枝长于顶枝状态，枝条平展，近轮生，树冠长圆形，当年生枝条紫绿色，有淡黄色的长毛；冬芽有淡褐色毛，花单性，雌雄异株或杂性，黄绿色，有芳香，花瓣缺，排列成顶生下垂的圆锥花序，花序梗有疏柔毛，果梗细小，种子红棕色，圆形。生于海拔400-2500米的低山区的山坡、山洼等落叶阔叶林和针阔叶混交林中</span></p>', 1, 1530671647, 1530672230);
COMMIT;

-- ----------------------------
-- Table structure for dp_base_user
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_user`;
CREATE TABLE `dp_base_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_phone` varchar(50) NOT NULL COMMENT '用户的手机号码',
  `openid` varchar(50) NOT NULL DEFAULT '0' COMMENT '用户的openid',
  `token` varchar(50) NOT NULL COMMENT '用户的身份令牌',
  `reg_ip` bigint(20) NOT NULL COMMENT '用户登录IP',
  `last_login_ip` bigint(20) NOT NULL COMMENT '用户最后登录IP',
  `last_login_time` int(10) NOT NULL COMMENT '最后登录时间',
  `reg_time` int(10) NOT NULL COMMENT '注册时间',
  `pay_pwd` char(50) NOT NULL DEFAULT '0' COMMENT '支付密码',
  `login_pwd` char(50) NOT NULL COMMENT '登录密码',
  `user_admin` enum('user_yes','user_no','user_frozen') NOT NULL DEFAULT 'user_no' COMMENT '是否是超级管理员  是超级管理员  不是  冻结',
  `pay_status` enum('pay_yes','pay_no') NOT NULL DEFAULT 'pay_yes' COMMENT '买入状态  可以买入  不可以买入',
  `postmoney_status` enum('post_yes','post_no') NOT NULL DEFAULT 'post_yes' COMMENT '提现状态    可以提现  不可以',
  `sell_status` enum('sell_yes','sell_no') NOT NULL DEFAULT 'sell_yes' COMMENT '卖出状态   可以卖出  你可以卖出',
  `user_uid` varchar(50) NOT NULL COMMENT '用户唯一标示',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户表前端';

-- ----------------------------
-- Table structure for dp_base_user_card
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_user_card`;
CREATE TABLE `dp_base_user_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(50) NOT NULL COMMENT '用户ID',
  `id_card_name` varchar(50) NOT NULL COMMENT '身份证姓名',
  `id_card_z` varchar(255) NOT NULL COMMENT '身份证正面',
  `id_card_f` varchar(255) NOT NULL COMMENT '身份证反面',
  `id_card_s` varchar(255) NOT NULL COMMENT '手持身份证',
  `id_card_number` varchar(50) NOT NULL COMMENT '身份证号码',
  `bank_card_title` varchar(50) NOT NULL COMMENT '客户银行',
  `back_card_holder` varchar(50) NOT NULL COMMENT '银行持卡人姓名',
  `bank_card_number` varchar(50) NOT NULL COMMENT '银行卡号',
  `ali_number` varchar(50) NOT NULL COMMENT '支付宝账号',
  `ali_user_name` varchar(50) NOT NULL COMMENT '用户支付宝名字',
  `card_status` enum('card_pass','card_nopass','card_inpass','card_noapprove') NOT NULL DEFAULT 'card_noapprove' COMMENT '认证状态  通过 没有通过 在认证  没有认证',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户身份信息';

-- ----------------------------
-- Table structure for dp_base_user_data
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_user_data`;
CREATE TABLE `dp_base_user_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(50) NOT NULL COMMENT '用户ID',
  `user_wallet_bag` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '用户钱包',
  `user_have_sapling` int(10) NOT NULL COMMENT '用户拥有的树苗',
  `user_ability_value` int(10) NOT NULL DEFAULT '0' COMMENT '用户能力值',
  `user_delivery_num` int(10) NOT NULL DEFAULT '0' COMMENT '用户交割数量',
  `user_prize_amount` decimal(9,2) NOT NULL COMMENT '用户奖励金额',
  `user_prize_score` int(10) NOT NULL COMMENT '用户奖励积分',
  `user_lock_sapling` int(10) NOT NULL COMMENT '用户锁仓数量',
  `user_group_sum` int(10) NOT NULL COMMENT '用户团购总数',
  `user_puid` varchar(50) NOT NULL COMMENT '用户推广上一级',
  `user_day_buynum` int(10) NOT NULL COMMENT '用户单日买入数量',
  `user_day_sellnum` int(10) NOT NULL COMMENT '用户单日卖出数量',
  `user_vip` int(3) NOT NULL DEFAULT '1' COMMENT '用户vip等级',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户钱包 时间林表';

-- ----------------------------
-- Table structure for dp_base_user_extend
-- ----------------------------
DROP TABLE IF EXISTS `dp_base_user_extend`;
CREATE TABLE `dp_base_user_extend` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '昵称',
  `photo` varchar(255) NOT NULL COMMENT '头像',
  `sex` tinyint(2) NOT NULL DEFAULT '0' COMMENT '性别',
  `city` varchar(200) DEFAULT NULL COMMENT '城市',
  `uid` varchar(50) NOT NULL COMMENT '用户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户扩展表';

-- ----------------------------
-- Table structure for dp_payment_wallet
-- ----------------------------
DROP TABLE IF EXISTS `dp_payment_wallet`;
CREATE TABLE `dp_payment_wallet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `money` decimal(10,2) DEFAULT NULL COMMENT '钱包金额',
  `secret` varchar(255) DEFAULT NULL COMMENT '钱包金额加密',
  `pay_password` varchar(255) DEFAULT NULL COMMENT '支付密码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for dp_cms_advert
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_advert`;
CREATE TABLE `dp_cms_advert` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `typeid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',
  `tagname` varchar(30) NOT NULL DEFAULT '' COMMENT '广告位标识',
  `ad_type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '广告类型',
  `timeset` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '时间限制:0-永不过期,1-在设内时间内有效',
  `start_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '开始时间',
  `end_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '结束时间',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT '广告位名称',
  `content` text NOT NULL COMMENT '广告内容',
  `expcontent` text NOT NULL COMMENT '过期显示内容',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='广告表';

-- ----------------------------
-- Table structure for dp_cms_advert_type
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_advert_type`;
CREATE TABLE `dp_cms_advert_type` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '分类名称',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='广告分类表';

-- ----------------------------
-- Table structure for dp_cms_column
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_column`;
CREATE TABLE `dp_cms_column` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '栏目名称',
  `model` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '文档模型id',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接',
  `target` varchar(16) NOT NULL DEFAULT '_self' COMMENT '链接打开方式',
  `content` text NOT NULL COMMENT '内容',
  `icon` varchar(64) NOT NULL DEFAULT '' COMMENT '字体图标',
  `index_template` varchar(32) NOT NULL DEFAULT '' COMMENT '封面模板',
  `list_template` varchar(32) NOT NULL DEFAULT '' COMMENT '列表页模板',
  `detail_template` varchar(32) NOT NULL DEFAULT '' COMMENT '详情页模板',
  `post_auth` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '投稿权限',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `hide` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏',
  `rank_auth` int(11) NOT NULL DEFAULT '0' COMMENT '浏览权限，-1待审核，0为开放浏览，大于0则为对应的用户角色id',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '栏目属性：0-最终列表栏目，1-外部链接，2-频道封面',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='栏目表';

-- ----------------------------
-- Table structure for dp_cms_document
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_document`;
CREATE TABLE `dp_cms_document` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '栏目id',
  `model` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '文档模型ID',
  `title` varchar(256) NOT NULL DEFAULT '' COMMENT '标题',
  `shorttitle` varchar(32) NOT NULL DEFAULT '' COMMENT '简略标题',
  `uid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `flag` set('j','p','b','s','a','f','c','h') DEFAULT NULL COMMENT '自定义属性',
  `view` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '阅读量',
  `comment` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评论数',
  `good` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '点赞数',
  `bad` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '踩数',
  `mark` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '收藏数量',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `trash` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '回收站',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文档基础表';

-- ----------------------------
-- Table structure for dp_cms_field
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_field`;
CREATE TABLE `dp_cms_field` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '字段名称',
  `name` varchar(32) NOT NULL,
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '字段标题',
  `type` varchar(32) NOT NULL DEFAULT '' COMMENT '字段类型',
  `define` varchar(128) NOT NULL DEFAULT '' COMMENT '字段定义',
  `value` text COMMENT '默认值',
  `options` text COMMENT '额外选项',
  `tips` varchar(256) NOT NULL DEFAULT '' COMMENT '提示说明',
  `fixed` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否为固定字段',
  `show` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否显示',
  `model` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '所属文档模型id',
  `ajax_url` varchar(256) NOT NULL DEFAULT '' COMMENT '联动下拉框ajax地址',
  `next_items` varchar(256) NOT NULL DEFAULT '' COMMENT '联动下拉框的下级下拉框名，多个以逗号隔开',
  `param` varchar(32) NOT NULL DEFAULT '' COMMENT '联动下拉框请求参数名',
  `format` varchar(32) NOT NULL DEFAULT '' COMMENT '格式，用于格式文本',
  `table` varchar(32) NOT NULL DEFAULT '' COMMENT '表名，只用于快速联动类型',
  `level` tinyint(2) unsigned NOT NULL DEFAULT '2' COMMENT '联动级别，只用于快速联动类型',
  `key` varchar(32) NOT NULL DEFAULT '' COMMENT '键字段，只用于快速联动类型',
  `option` varchar(32) NOT NULL DEFAULT '' COMMENT '值字段，只用于快速联动类型',
  `pid` varchar(32) NOT NULL DEFAULT '' COMMENT '父级id字段，只用于快速联动类型',
  `ak` varchar(32) NOT NULL DEFAULT '' COMMENT '百度地图appkey',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='文档字段表';

-- ----------------------------
-- Records of dp_cms_field
-- ----------------------------
BEGIN;
INSERT INTO `dp_cms_field` VALUES (1, 'id', 'ID', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', 'ID', 0, 0, 0, '', '', '', '', '', 0, '', '', '', '', 1480562978, 1480562978, 100, 1);
INSERT INTO `dp_cms_field` VALUES (2, 'cid', '栏目', 'select', 'int(11) UNSIGNED NOT NULL', '0', '', '请选择所属栏目', 0, 0, 0, '', '', '', '', '', 0, '', '', '', '', 1480562978, 1480562978, 100, 1);
INSERT INTO `dp_cms_field` VALUES (3, 'uid', '用户ID', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', 0, 0, 0, '', '', '', '', '', 0, '', '', '', '', 1480563110, 1480563110, 100, 1);
INSERT INTO `dp_cms_field` VALUES (4, 'model', '模型ID', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', 0, 0, 0, '', '', '', '', '', 0, '', '', '', '', 1480563110, 1480563110, 100, 1);
INSERT INTO `dp_cms_field` VALUES (5, 'title', '标题', 'text', 'varchar(128) NOT NULL', '', '', '文档标题', 0, 1, 0, '', '', '', '', '', 0, '', '', '', '', 1480575844, 1480576134, 1, 1);
INSERT INTO `dp_cms_field` VALUES (6, 'shorttitle', '简略标题', 'text', 'varchar(32) NOT NULL', '', '', '简略标题', 0, 1, 0, '', '', '', '', '', 0, '', '', '', '', 1480575844, 1480576134, 1, 1);
INSERT INTO `dp_cms_field` VALUES (7, 'flag', '自定义属性', 'checkbox', 'set(\'j\',\'p\',\'b\',\'s\',\'a\',\'f\',\'h\',\'c\') NULL DEFAULT NULL', '', 'j:跳转\r\np:图片\r\nb:加粗\r\ns:滚动\r\na:特荐\r\nf:幻灯\r\nh:头条\r\nc:推荐', '自定义属性', 0, 1, 0, '', '', '', '', '', 0, '', '', '', '', 1480671258, 1480671258, 100, 1);
INSERT INTO `dp_cms_field` VALUES (8, 'view', '阅读量', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', 0, 1, 0, '', '', '', '', '', 0, '', '', '', '', 1480563149, 1480563149, 100, 1);
INSERT INTO `dp_cms_field` VALUES (9, 'comment', '评论数', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', 0, 0, 0, '', '', '', '', '', 0, '', '', '', '', 1480563189, 1480563189, 100, 1);
INSERT INTO `dp_cms_field` VALUES (10, 'good', '点赞数', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', 0, 0, 0, '', '', '', '', '', 0, '', '', '', '', 1480563279, 1480563279, 100, 1);
INSERT INTO `dp_cms_field` VALUES (11, 'bad', '踩数', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', 0, 0, 0, '', '', '', '', '', 0, '', '', '', '', 1480563330, 1480563330, 100, 1);
INSERT INTO `dp_cms_field` VALUES (12, 'mark', '收藏数量', 'text', 'int(11) UNSIGNED NOT NULL', '0', '', '', 0, 0, 0, '', '', '', '', '', 0, '', '', '', '', 1480563372, 1480563372, 100, 1);
INSERT INTO `dp_cms_field` VALUES (13, 'create_time', '创建时间', 'datetime', 'int(11) UNSIGNED NOT NULL', '0', '', '', 0, 0, 0, '', '', '', '', '', 0, '', '', '', '', 1480563406, 1480563406, 100, 1);
INSERT INTO `dp_cms_field` VALUES (14, 'update_time', '更新时间', 'datetime', 'int(11) UNSIGNED NOT NULL', '0', '', '', 0, 0, 0, '', '', '', '', '', 0, '', '', '', '', 1480563432, 1480563432, 100, 1);
INSERT INTO `dp_cms_field` VALUES (15, 'sort', '排序', 'text', 'int(11) NOT NULL', '100', '', '', 0, 1, 0, '', '', '', '', '', 0, '', '', '', '', 1480563510, 1480563510, 100, 1);
INSERT INTO `dp_cms_field` VALUES (16, 'status', '状态', 'radio', 'tinyint(2) UNSIGNED NOT NULL', '1', '0:禁用\r\n1:启用', '', 0, 1, 0, '', '', '', '', '', 0, '', '', '', '', 1480563576, 1480563576, 100, 1);
INSERT INTO `dp_cms_field` VALUES (17, 'trash', '回收站', 'text', 'tinyint(2) UNSIGNED NOT NULL', '0', '', '', 0, 0, 0, '', '', '', '', '', 0, '', '', '', '', 1480563576, 1480563576, 100, 1);
COMMIT;

-- ----------------------------
-- Table structure for dp_cms_link
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_link`;
CREATE TABLE `dp_cms_link` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '类型：1-文字链接，2-图片链接',
  `title` varchar(128) NOT NULL DEFAULT '' COMMENT '链接标题',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `logo` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '链接LOGO',
  `contact` varchar(255) NOT NULL DEFAULT '' COMMENT '联系方式',
  `sort` int(11) NOT NULL DEFAULT '100',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='有钱链接表';

-- ----------------------------
-- Table structure for dp_cms_menu
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_menu`;
CREATE TABLE `dp_cms_menu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '导航id',
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
  `column` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '栏目id',
  `page` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '单页id',
  `type` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '类型：0-栏目链接，1-单页链接，2-自定义链接',
  `title` varchar(128) NOT NULL DEFAULT '' COMMENT '菜单标题',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接',
  `css` varchar(64) NOT NULL DEFAULT '' COMMENT 'css类',
  `rel` varchar(64) NOT NULL DEFAULT '' COMMENT '链接关系网',
  `target` varchar(16) NOT NULL DEFAULT '' COMMENT '打开方式',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='菜单表';

-- ----------------------------
-- Records of dp_cms_menu
-- ----------------------------
BEGIN;
INSERT INTO `dp_cms_menu` VALUES (1, 1, 0, 0, 0, 2, '首页', 'cms/index/index', '', '', '_self', 1492345605, 1492345605, 100, 1);
INSERT INTO `dp_cms_menu` VALUES (2, 2, 0, 0, 0, 2, '关于我们', 'http://www.dolphinphp.com', '', '', '_self', 1492346763, 1492346763, 100, 1);
INSERT INTO `dp_cms_menu` VALUES (3, 3, 0, 0, 0, 2, '开发文档', 'http://www.kancloud.cn/ming5112/dolphinphp', '', '', '_self', 1492346812, 1492346812, 100, 1);
INSERT INTO `dp_cms_menu` VALUES (4, 3, 0, 0, 0, 2, '开发者社区', 'http://bbs.dolphinphp.com/', '', '', '_self', 1492346832, 1492346832, 100, 1);
INSERT INTO `dp_cms_menu` VALUES (5, 1, 0, 0, 0, 2, '二级菜单', 'http://www.dolphinphp.com', '', '', '_self', 1492347372, 1492347510, 100, 1);
INSERT INTO `dp_cms_menu` VALUES (6, 1, 5, 0, 0, 2, '子菜单', 'http://www.dolphinphp.com', '', '', '_self', 1492347388, 1492347520, 100, 1);
COMMIT;

-- ----------------------------
-- Table structure for dp_cms_model
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_model`;
CREATE TABLE `dp_cms_model` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '模型名称',
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '模型标题',
  `table` varchar(64) NOT NULL DEFAULT '' COMMENT '附加表名称',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '模型类别：0-系统模型，1-普通模型，2-独立模型',
  `icon` varchar(64) NOT NULL,
  `sort` int(11) NOT NULL DEFAULT '100' COMMENT '排序',
  `system` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '是否系统模型',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='内容模型表';

-- ----------------------------
-- Table structure for dp_cms_nav
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_nav`;
CREATE TABLE `dp_cms_nav` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `tag` varchar(32) NOT NULL DEFAULT '' COMMENT '导航标识',
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '菜单标题',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='导航表';

-- ----------------------------
-- Records of dp_cms_nav
-- ----------------------------
BEGIN;
INSERT INTO `dp_cms_nav` VALUES (1, 'main_nav', '顶部导航', 1492345083, 1492345083, 1);
INSERT INTO `dp_cms_nav` VALUES (2, 'about_nav', '底部关于', 1492346685, 1492346685, 1);
INSERT INTO `dp_cms_nav` VALUES (3, 'support_nav', '服务与支持', 1492346715, 1492346715, 1);
COMMIT;

-- ----------------------------
-- Table structure for dp_cms_page
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_page`;
CREATE TABLE `dp_cms_page` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(64) NOT NULL DEFAULT '' COMMENT '单页标题',
  `content` mediumtext NOT NULL COMMENT '单页内容',
  `keywords` varchar(32) NOT NULL DEFAULT '' COMMENT '关键词',
  `description` varchar(250) NOT NULL DEFAULT '' COMMENT '页面描述',
  `template` varchar(32) NOT NULL DEFAULT '' COMMENT '模板文件',
  `cover` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '单页封面',
  `view` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '阅读量',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='单页表';

-- ----------------------------
-- Table structure for dp_cms_slider
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_slider`;
CREATE TABLE `dp_cms_slider` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '标题',
  `cover` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '封面id',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='滚动图片表';

-- ----------------------------
-- Table structure for dp_cms_support
-- ----------------------------
DROP TABLE IF EXISTS `dp_cms_support`;
CREATE TABLE `dp_cms_support` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL DEFAULT '' COMMENT '客服名称',
  `qq` varchar(16) NOT NULL DEFAULT '' COMMENT 'QQ',
  `msn` varchar(100) NOT NULL DEFAULT '' COMMENT 'msn',
  `taobao` varchar(100) NOT NULL DEFAULT '' COMMENT 'taobao',
  `alibaba` varchar(100) NOT NULL DEFAULT '' COMMENT 'alibaba',
  `skype` varchar(100) NOT NULL DEFAULT '' COMMENT 'skype',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  `sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='客服表';

-- ----------------------------
-- Table structure for dp_crontab
-- ----------------------------
DROP TABLE IF EXISTS `dp_crontab`;
CREATE TABLE `dp_crontab` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `type` varchar(10) NOT NULL COMMENT '类型',
  `title` varchar(150) NOT NULL COMMENT '标题',
  `content` text NOT NULL COMMENT '内容',
  `schedule` varchar(100) NOT NULL COMMENT 'Cron 表达式',
  `sleep` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '延迟秒数执行',
  `maximums` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大执行次数 0为不限',
  `executes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已经执行的次数',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `begin_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '开始时间',
  `end_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '结束时间',
  `execute_time` int(10) unsigned DEFAULT NULL COMMENT '最后执行时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `status` enum('completed','expired','disable','normal') NOT NULL DEFAULT 'normal' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='定时任务表';

-- ----------------------------
-- Table structure for dp_crontab_log
-- ----------------------------
DROP TABLE IF EXISTS `dp_crontab_log`;
CREATE TABLE `dp_crontab_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL COMMENT '类型',
  `cid` int(10) unsigned NOT NULL COMMENT '任务的ID',
  `title` varchar(150) NOT NULL COMMENT '标题',
  `remark` mediumtext COMMENT '备注',
  `create_time` int(10) unsigned NOT NULL COMMENT '执行时间',
  `status` tinyint(1) NOT NULL COMMENT '状态 0:失败 1:成功',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务日志表';

-- ----------------------------
-- Table structure for dp_payment_order
-- ----------------------------
DROP TABLE IF EXISTS `dp_payment_order`;
CREATE TABLE `dp_payment_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户充值表',
  `order_sn` varchar(50) NOT NULL COMMENT '订单编号',
  `member_id` varchar(50) NOT NULL COMMENT '用户id',
  `user_money` decimal(9,2) NOT NULL COMMENT '充值金额',
  `pay_sn` varchar(50) NOT NULL COMMENT '回执单',
  `pay_titlename` varchar(50) NOT NULL COMMENT '支付标题',
  `paytime` int(10) NOT NULL COMMENT '支付时间',
  `reality_money` decimal(9,2) NOT NULL COMMENT '实际到账',
  `pay_type` enum('alipay','weixin') DEFAULT NULL COMMENT '支付方式',
  `status` enum('nopay','yespass','yespay') NOT NULL DEFAULT 'nopay' COMMENT '审核状态  没有支付  通过审核   充值成功',
  `create_time` int(11) NOT NULL COMMENT '充值时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='微信，支付宝支付表';

-- ----------------------------
-- Table structure for dp_plugin_sms
-- ----------------------------
DROP TABLE IF EXISTS `dp_plugin_sms`;
CREATE TABLE `dp_plugin_sms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '模板名称',
  `code` varchar(128) NOT NULL DEFAULT '' COMMENT '模板id',
  `sign_name` varchar(128) NOT NULL DEFAULT '' COMMENT '短信签名',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='短信模板表';

SET FOREIGN_KEY_CHECKS = 1;
